DBA_AUDIT_MGMT_CONFIG_PARAMS

DBA_AUDIT_MGMT_CONFIG_PARAMS displays information about the currently configured audit trail properties that are used by the DBMS_AUDIT_MGMT PL/SQL package.

Note:

This view is populated in any Oracle Database where auditing is enabled, regardless of whether pre-Oracle Database 12c auditing or unified auditing is enabled for the database.

Column Datatype NULL Description
PARAMETER_NAME VARCHAR2(1024) NOT NULL Name of the property
PARAMETER_VALUE VARCHAR2(4000)   Value of the property
AUDIT_TRAIL VARCHAR2(28)  

Audit trails for which the property is configured:

  • STANDARD AUDIT TRAIL

  • FGA AUDIT TRAIL

  • STANDARD AND FGA AUDIT TRAIL

  • OS AUDIT TRAIL

  • XML AUDIT TRAIL

  • OS AND XML AUDIT TRAIL

  • ALL AUDIT TRAILS

  • UNIFIED AUDIT TRAIL

Note: In a read-only database, including an Oracle Active Data Guard physical standby database, this view is not populated when the DBMS_AUDIT_MGMT.SET_AUDIT_TRAIL PL/SQL procedure is invoked. If the procedure was used when the database was in read-only mode, use DBMS_AUDIT_MGMT.GET_AUDIT_TRAIL to check the value of the property.

See Also: Oracle AI Database PL/SQL Packages and Types Reference for more information about the parameters specified with the DBMS_AUDIT_MGMT.SET_AUDIT_TRAIL_PROPERTY procedure