Database Security Products (MOSC)

MOSC Banner

Question on Audit Purge Doc ID 2573372.1

edited Aug 11, 2024 12:35AM in Database Security Products (MOSC) 1 commentAnswered ✓

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;

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center