How to Speed Up CLEAN_AUDIT_TRAIL
CLEAN_AUDIT_TRAIL Runs Slowly ? If you have never purged the unified audit trails in your database, the first time deletion by CLEAN_AUDIT_TRAIL may take a… Read More »How to Speed Up CLEAN_AUDIT_TRAIL
DBMS_AUDIT_MGMT
How to Purge Unified Audit Trail in Oracle
Tablespace SYSAUX Since tablespace SYSAUX has grown too big, so we query V$SYSAUX_OCCUPANTS to check the usage of AUDSYS in SYSAUX like this: SQL> show… Read More »How to Purge Unified Audit Trail in Oracle
How to Check LAST_ARCHIVE_TIME
Before you purge some unified audit trails, you may like to know what the current value of LAST_ARCHIVE_TIME has been set by SET_LAST_ARCHIVE_TIMESTAMP. Theoretically, we… Read More »How to Check LAST_ARCHIVE_TIME