How do you validate that the database was migrated to Unified Auditing?

The V$OPTION dynamic performance view lists database features and options that are installed and enabled. To validate that a database is running in pure unified auditing mode (i.e., has been migrated), you query this view. If the parameter 'Unified Auditing' has a value of 'TRUE', it confirms the feature is fully enabled at the database kernel level. This is the definitive method for verification.

B: lsinventory is an OPatch utility that queries the Oracle Home software installation, not the runtime configuration of a database. C: DBAUNIFIEDAUDITOPTION shows which audit policies are enabled, but does not confirm the database is in pure unified auditing mode. D: The DBMSAUDITMGMT package is used for managing audit data and policies, not for verifying the database's auditing mode.

1. Oracle Database Security Guide, 23ai, Chapter 19, "Introduction to Auditing", Section "Verifying That Unified Auditing Is Enabled". The guide states: "To verify that unified auditing has been enabled, query the V$OPTION view."

2. Oracle Database Reference, 23ai, "V$OPTION". This document describes the view and lists 'Unified Auditing' as one of the parameters it displays.