Last updated on FEBRUARY 03, 2012
Applies to:Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 10.2.0.5 - Release: 10.1 to 10.2
Information in this document applies to any platform.
RMAN seems to hang on exit. If you just connect to target database and then exit, RMAN takes 10-15 minutes in finishing the session. List or Report commands generate the correct ouput and then spend 10-15 minutes before returning to the RMAN prompt.
If you get the 10046 traces, you will see that the RMAN session is executing a query over v$rman_status view that takes over 15 minutes. The slow performace query is similar to the following:
select round(sum(MBYTES_PROCESSED)) ,round(sum(INPUT_BYTES)) ,round(sum(OUTPUT_BYTES))
start with (RECID= .. and STAMP= ... )
connect by prior RECID=parent_recid
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms