Question on Audit Purge Doc ID 2573372.1
Hello All,
Running Oracle 19.24 cdb/pdb on RHEL8
The audit purge job will run for about a day on each PDB.
We are configured to partition by day, just like below and have been so its not a new purge.
BEGIN
 DBMS_AUDIT_MGMT.ALTER_PARTITION_INTERVAL(
   interval_number       => 1,
   interval_frequency    => 'DAY');
 END;
/
Audit purge Job
DECLARE
l_days   NUMBER := 7;
BEGIN
DBMS_AUDIT_MGMT.SET_LAST_ARCHIVE_TIMESTAMP (DBMS_AUDIT_MGMT.AUDIT_TRAIL_UNIFIED, TRUNC (SYSTIMESTAMP) - l_days);
DBMS_AUDIT_MGMT.clean_audit_trail (audit_trail_type          => DBMS_AUDIT_MGMT.AUDIT_TRAIL_UNIFIED,
use_last_arch_timestamp   => TRUE);
END;
