← 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