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
Unified Audit Trail
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"