Recently RMAN backup failed after 10g upgrade. On digging in error logs, the following was discovered:
SQL> select count(*) from v$rman_status ;
select count(*) from v$rman_status
*
ERROR at line 1:
ORA-01652: unable to extend temp segment by 640 in tablespace TEMP
Incorrect statistics on FIXED objects
Bad execution plan needed much sort-space.
Multiple waitevents on 'direct path write temp'.
Fix: As per Metalink Note 357765.1
SQL> exec dbms_stats.gather_fixed_objects_stats;
Blog dedicated to Oracle Applications (E-Business Suite) Technology; covers Apps Architecture, Administration and third party bolt-ons to Apps
Showing posts with label gather statistics on fixed objects. Show all posts
Showing posts with label gather statistics on fixed objects. Show all posts
Friday, August 29, 2008
Subscribe to:
Posts (Atom)