DBA Hub

📋Steps in this guide1/1

Enable audit for sys operations

SQL> ALTER SYSTEM SET audit_sys_operations=true SCOPE=spfile;

oracle configurationintermediate
by OracleDba
13 views
1

Enable audit for sys operations

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
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

Comments (0)

Please to add comments

No comments yet. Be the first to comment!