Statements audited in oracle
col user_name
FOR a12 heading "User name" col audit_option format a30 heading "Audit Option"
SET pages 1000 prompt prompt SYSTEM auditing OPTIONS across the SYSTEM
AND BY USER
SELECT user_name,
audit_option,
success,
failure
FROM sys.dba_stmt_audit_opts
ORDER BY user_name,
proxy_name,
audit_option /