"recovery area: computing obsolete files" Wait Observed
(Doc ID 2750198.1)
Last updated on MARCH 31, 2021
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 and later
Information in this document applies to any platform.
During review of the waits registered in AWR you can see a wait class "recovery area: computing obsolete files", which may be excessive during quiet periods. You may also see this
first boolean := FALSE;
if (:first > 0)
first := TRUE;
ret := dbms_rcvman.listBackup( lbRecOut => lbRec, firstCall => first, only_obsolete => TRUE, redundancy => :redundancy, piped_call => FALSE, lbCursor => lbCursor, lbState => dbms_rcvman.lbStatePck, extRlKeepSCN => NULL);
if (not ret) then raise no_data_found;
elsif (lbRec.pkey is not null and lbRec.is_rdf = 'YES') then :backup_type := lbRec.backup_type;
:file_type := lbRec.file_type;
:key := lbRec.pkey; else first := FALSE;
In quiet periods an run of dbms_rcvman with listBackup may cause excessive waits when they are not expected. This command may be manually run or may be part of an automated process.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document