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
CLEAR_LAST_ARCHIVE_TIMESTAMP
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