They are... Quickly followed by a call to dbms_stats.delete_fixed_object_stats(); :-D RF Robert G. Freeman Author: Oracle Database 11g New Features (Oracle Press) Portable DBA: Oracle (Oracle Press) Oracle Database 10g New Features (Oracle Press) Oracle9i RMAN Backup and Recovery (Oracle Press) Oracle9i New Feature Blog: http://robertgfreeman.blogspot.com (Oracle Press) ----- Original Message ---- From: "Taylor, Chris David" <Chris.Taylor@xxxxxxxxxxxxxxx> To: don@xxxxxxxxx; oracle-l <oracle-l@xxxxxxxxxxxxx> Sent: Monday, February 11, 2008 4:09:37 PM Subject: RE: Tuning RMAN backup and recovery You mean you weren't using dbms_stats.gather_fixed_objects_stats()?? I thought EVERYONE was using that by now... KIDDING!! Only kidding! Chris Taylor Sr. Oracle DBA Ingram Barge Company Nashville, TN 37205 Office: 615-517-3355 Cell: 615-354-4799 Email: chris.taylor@xxxxxxxxxxxxxxx -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Don Seiler Sent: Monday, February 11, 2008 3:55 PM To: oracle-l Subject: Re: Tuning RMAN backup and recovery Just wanted to follow-up here as well. I finally decided to file an SR, and Oracle came back pretty quickly with Note 462879.1 [0], fixed in 10.2.0.4 and 11g. It seems that, in this bug, queries against v$rman_status table can take an extremely long time, and that table is queried for every datafile switch during RMAN DUPLICATEs Workarounds are to either set sesiion-level optimization to RULE based, or to gather fixed object statistics via dbms_stats.gather_fixed_objects_stats();. I've done the latter, but haven't had an opportunity to perform another restore as our development instances are needed until the next release in two weeks. I'll report back with results when I do. [0] https://metalink.oracle.com/metalink/plsql/f?p=130:14:698790149932005062 0::::p14_database_id,p14_docid,p14_show_header,p14_show_help,p14_black_f rame,p14_font:NOT,462879.1,1,1,1,helvetica -- Don Seiler http://seilerwerks.wordpress.com ultimate: http://www.mufc.us -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l