My Oracle Support Banner

RMAN: High Number of Executions Of SQL_ID : 6zq7whdtnf2ru (Doc ID 2689867.1)

Last updated on SEPTEMBER 04, 2020

Applies to:

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

Symptoms

  AWR shows high number of execution of the following SQL statement:

SQL_ID: 6zq7whdtnf2ru

declare agedFileRec dbms_rcvman.agedFileRec_t;
first boolean := FALSE;
alldest number := dbms_rcvman.FALSE#;
policy varchar2(512);

begin if (:first > 0)
     then first := TRUE; if (:alldest > 0) then alldest := dbms_rcvman.TRUE#; end if; dbms_rcvman.setRecoveryDestFile(TRUE); dbms_rcvman.getRedoLogDeletionPolicy(policy => policy); dbms_rcvman.setRedoLogDeletionPolicy(policy => policy, alldest => alldest); end if; dbms_rcvman.getBackedUpFiles(first => first, agedFileRec => agedFileRec); :type := agedFileRec.type; :key := agedFileRec.key; end;

Changes

 N/A

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.