打开审计功能
conn / as sysdba
@$ORACLE_HOME/rdbms/admin/cataudit.sql ---安装审计
audit session; --审计会话alter system set audit_sys_operations=TRUE scope=spfile; --修改审计参数
alter system set audit_trail=db,extended scope=spfile;
startup force; --重启
select * from aud$; --审计的视图
select * from dba_audit_trail;
关闭审计
alter system set audit_sys_operations=FALSE scope=spfile;
alter system set audit_trail=NONE scope=spfile;
delete aud$;
noaudit session;
startup force;