Rman Slow Performance on Exit (Doc ID 373152.1)

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.

Symptoms

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))
from V$RMAN_STATUS
start with (RECID= .. and STAMP= ... )
connect by prior RECID=parent_recid

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms