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
Auditing
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
Why Enable Unified Audit Trail in 12c
In my opinion, the reason in short is that the unified audit systematically unify all required audit operations into a single, consolidated fashion.According Oracle 12c… Read More »Why Enable Unified Audit Trail in 12c
The Scope of "AUDIT POLICY XXX"
When you issue the very simple unified audit without any modifiers like this:SQL> AUDIT POLICY ORA_DATABASE_PARAMETER; The scope of the audit seems to be very… Read More »The Scope of "AUDIT POLICY XXX"