dba_stmt_audit_opts shows current system audition options. select user_name, proxy_name, audit_option, success, failure from dba_stmt_audit_opts;
audit all statements; noaudit all statements;
audit and noaudit is likely to throw ORA-46401: No new traditional AUDIT configuration is allowed. Traditional auditing is desupported, and you should use unified auditing in its place. in 23ai or later.