[Oracle-l] RMAN Catalog ops slow

there are/were a number of performance issues with the rman catalog. I'd
check out metalink and/or your rman version.

You probably want to run dbms_stats with a gather_fixed_stats - Like
Nail said there are some performance issues with RMAN, Export, Expdp
etc. - if your high-cpu queries show a lot of selects against
$HIST_HEAD then this can help.



We run this as a standard procedure, and it helps to stop / start the
database although flushing the shared pool -might- help.



From: oracle-l-bounce_at_freelists.org
On Behalf Of Howard Latham
Sent: Wednesday, July 29, 2009 11:51 AM
To: ORACLE-L
Subject: RMAN Catalog ops slow



I am trying to delete about 8000 expired objects in rman and, well I
waited a day and it still hasnt finished!
Is my catalog sick?
Oracle 10g Linux

See 247611.1 - Known RMAN Performance Problems (a long list of Notes for
RMAN Performance Problems)
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist