In addition, you can create policies that use conditions. However, if you want to audit specific columns or use event handlers, you must use fine-grained auditing.
The general steps for performing this type of auditing are as follows:
In most cases, use the CREATE AUDIT POLICY statement to create an audit policy. If you must audit application context values, then use the AUDIT statement.
See the relevant categories under Auditing Activities with Unified Audit Policies and the AUDIT Statement.
If you are creating an audit policy, then use the AUDIT statement to enable it and optionally apply (or exclude) the audit settings to one or more users, including administrative users who log in with the SYSDBA administrative privilege (for example, the SYS user).
AUDIT also enables you to create an audit record upon an action's success, failure, or both.
See Enabling Unified Audit Policies to Users.
Query the UNIFIED_AUDIT_TRAIL view to find the generated audit records.
See also Audit Policy Data Dictionary Views for additional views.
Periodically archive and purge the contents of the audit trail.
See Purging Audit Trail Records.
