How to check traditional audit settings in Oracle

Show the traditional (pre-Unified) audit configuration: statement, privilege, and object audit options. Traditional auditing is deprecated in newer releases in favour of Unified Auditing.

-- Statement audit options
SELECT user_name, audit_option, success, failure
FROM   dba_stmt_audit_opts
ORDER  BY user_name, audit_option;

-- Privilege audit options
SELECT user_name, privilege, success, failure
FROM   dba_priv_audit_opts
ORDER  BY user_name, privilege;

-- Object audit options
SELECT owner, object_name, object_type, alt, aud, del, sel, upd
FROM   dba_obj_audit_opts
WHERE  owner NOT IN ('SYS','SYSTEM')
ORDER  BY owner, object_name;