Last updated on OCTOBER 31, 2016
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.2 and later
Information in this document applies to any platform.
RMAN back is suddenly running very slowly after having deleted a large number of backups.
TKPROF shows problem sql is:
OBJECT_DATA , TYPE , ( CASE WHEN TYPE = 'DATAFILE RENAME ON RESTORE' THEN
DF.NAME WHEN TYPE = 'TEMPFILE RENAME' THEN TF.NAME ELSE TO_CHAR ( NULL )
END) OBJECT_FNAME , ( CASE WHEN TYPE = 'DATAFILE RENAME ON RESTORE'
THEN DF.CREATION_CHANGE# WHEN TYPE = 'TEMPFILE RENAME' THEN
TF.CREATION_CHANGE# ELSE TO_NUMBER ( NULL ) END) OBJECT_CREATE_SCN ,
SET_STAMP , SET_COUNT
V$DELETED_OBJECT , V$DATAFILE DF , V$TEMPFILE TF WHERE OBJECT_DATA =
DF.FILE# (+) AND OBJECT_DATA = TF.FILE# (+) AND RECID BETWEEN :1 AND
:1 AND ( STAMP >= :1 OR RECID = :1 ) AND STAMP >= :1 ORDER BY 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