Home » RDBMS Server » Performance Tuning » Difference between cost and bytes (10g)
Difference between cost and bytes [message #469251] Wed, 04 August 2010 01:38 Go to next message
soraociscocom
Messages: 1
Registered: August 2010
Location: Blore
Junior Member
I am working on Tuning a Materialized view. I was getting an error saying ORA-12008: error in materialized view refresh path
ORA-12801: error signaled in parallel query server P002, instance hrms-stg-db01:HRSTG1 (1)
ORA-01652: unable to extend temp segment by 16 in tablespace TEMP1. so i incraesed the temp size. I am tryig out various hints to get it rectified. But i am not sure if i should go for less costt or less bytes. Can anyone guide me
Re: Difference between cost and bytes [message #469252 is a reply to message #469251] Wed, 04 August 2010 01:40 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Can anyone guide me

go for no ERROR
Previous Topic: delete no of records
Next Topic: Performance issue - Views inside a view
Goto Forum:
  


Current Time: Mon Nov 25 05:23:37 CST 2024