12c Unified Auditing (12c New Features)
Unified Audit (12c New Features) ------------------------------------------- new parameter: UNIFIED_AUDIT_SGA_QUEUE_SIZE (1 MB to 30MB) is introduced. This parameter configures the size of SGA queue for unified auditing. UNIFIED AUDIT: ----------------------- QUEUED Mode (default). Audit records stored in the SGA and periodically flushed. Immediate: Audit records written immediately. Roles: ------- AUDIT_ADMIN and AUDIT_VIEWER to administer unified auditing. Create auditing policy ----------------------- SQL> create audit policy mono_audit privileges alter database, select any table actions logon, select on HR.employees; 2 3 4 5 Audit policy created. SQL> audit policy mono_audit; Audit succeeded. ENABLE AUDIT POLICY --------------------------------- enable audit for all users SQL> audit policy mono_audit ; Audit succeeded. Check Audit : ...