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;