← Security
Oracle · Security
How to check if Unified Auditing is enabled in Oracle
Check whether Unified Auditing is linked into the instance using V$OPTION, which decides where audit records are written.
Tested on12c18c19c21c23ai26ai
Check whether Unified Auditing is linked in. It changes where audit records go (a TRUE value means pure unified auditing).
SELECT value AS unified_auditing
FROM v$option
WHERE parameter = 'Unified Auditing';SecurityAuditingUnified Auditing