Audit

-- turn on audit

ALTER SYSTEM SET AUDIT_TRAIL=OS SCOPE=SPFILE;--can't update online

alter system set audit_file_dest='/u01/app/oracle/audit/adump' SCOPE=SPFILE;

alter system set audit_file_dest='/u02/oracle/audit/adump/' SCOPE=SPFILE;

alter system set audit_sys_operations=TRUE SCOPE=SPFILE;

noaudit session by DBSNMP;

audit session by session;

audit table;

audit tablespace;

audit system grant;

audit user;

audit view;

audit trigger;

select * from AUDIT_ACTIONS;

SELECT * FROM DBA_STMT_AUDIT_OPTS;

SHOW PARAMETER AUDIT_TRAIL;

http://oracleflash.com/16/audit-trail-example-in-oracle-10gr2.html