Enable audit for sys operations - Oracle Database Script. SQL> ALTER SYSTEM SET audit_sys_operations=TRUE SCOPE=spfile; SQL> SHUTDOWN IMMEDIATE SQL> STARTUP SQL> SHOW PARAMETER audit_sys_operations NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ audit_sys_operations boolean TRUE
SQL> ALTER SYSTEM SET audit_sys_operations=TRUE SCOPE=spfile; SQL> SHUTDOWN IMMEDIATE SQL> STARTUP SQL> SHOW PARAMETER audit_sys_operations NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ audit_sys_operations boolean TRUE