My Oracle Support Banner

"recovery area: computing obsolete files" Wait Observed (Doc ID 2750198.1)

Last updated on MARCH 31, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

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

0az7czjdw8z7j

declare
lbRec dbms_rcvman.lbRec_t;
lbCursor dbms_rcvman.lbCursor_t;
first boolean := FALSE;
ret boolean;
begin
 if (:first > 0)
 then
   first := TRUE;
 end if;
 <>
   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;
 goto next_row;
 end if;
end;

 

Changes

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.

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.