RMAN: High Number of Executions Of SQL_ID : 6zq7whdtnf2ru
(Doc ID 2689867.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 12.2.0.1 and laterInformation 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 |