Statements audited in oracle

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 /