Verify Your Oracle Database Audit Settings

You can verify your Oracle Database audit settings manually. Do one of the following, depending on your Oracle Database version and edition.

Oracle Database version/edition	Command
Oracle Database 19c, 21c, 23c (Unified Auditing)	select ENTITY_NAME, ENABLED_OPTION, SUCCESS, FAILURE from AUDIT_UNIFIED_ENABLED_POLICIES;
Oracle Database 12c, 18c (Unified Auditing)	select USER_NAME, ENABLED_OPT, SUCCESS, FAILURE from AUDIT_UNIFIED_ENABLED_POLICIES;
Oracle Database Enterprise Edition (Fine Grained Auditing)	SELECT POLICY_NAME, ENABLED from DBA_AUDIT_POLICIES;

If you want to clean your audit settings periodically, refer to the following Oracle Help Center article for more information: Database PL/SQL Packages and Types Reference