13 DBMS_AUDIT_MGMT Data Dictionary Views

The DBMS_AUDIT_MGMT data dictionary views describe audit configuration settings that you create with the DBMS_AUDIT_MGMT PL/SQL package. Chapter 14 describes this package in detail.

Table 13-1 lists data dictionary views that are described in this section.

Table 13-1 DBMS_AUDIT_MGMT Data Dictionary Views

Data Dictionary View	Description
DBA_AUDIT_MGMT_CONFIG_PARAMS	Displays the currently configured audit trail properties that are used by the `DBMS_AUDIT_MGMT` PL/SQL package
DBA_AUDIT_MGMT_LAST_ARCH_TS	Displays the last archive timestamps that have been set for audit trail cleanup or purges.
DBA_AUDIT_MGMT_CLEANUP_JOBS	Displays the currently configured audit trail cleanup or purge jobs
DBA_AUDIT_MGMT_CLEAN_EVENTS	Displays the history of cleanup or purge events. Periodically, as user `SYS` connected with the `SYSDBA` privilege, you should delete the contents of this view so that it will not grow too large. For example: DELETE FROM DBA_AUDIT_MGMT_CLEAN_EVENTS;

13.1 DBA_AUDIT_MGMT_CONFIG_PARAMS

The DBA_AUDIT_MGMT_CONFIG_PARAMS data dictionary view displays the currently configured audit trail properties that are used by the DBMS_AUDIT_MGMT PL/SQL package.

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`

13.2 DBA_AUDIT_MGMT_LAST_ARCH_TS

The DBA_AUDIT_MGMT_LAST_ARCH_TS data dictionary view displays the last archive timestamps set for audit trail cleanup or purges.

Column	Datatype	Null	Description
`AUDIT_TRAIL`	`VARCHAR2(20)`		Audit trail for which the last archive timestamp applies: `STANDARD AUDIT TRAIL` `FGA AUDIT TRAIL` `OS AUDIT TRAIL` `XML AUDIT TRAIL`
`RAC_INSTANCE`	`NUMBER`	`NOT NULL`	Oracle RAC instance number for which the last archive timestamp applies. 0 implies "Not Applicable".
`LAST_ARCHIVE_TS`	`TIMESTAMP(6) WITH TIMEZONE`		Timestamp of the last audit record or audit file that has been archived

13.3 DBA_AUDIT_MGMT_CLEANUP_JOBS

The DBA_AUDIT_MGMT_CLEANUP_JOBS data dictionary view displays the currently configured audit trail cleanup or purge jobs.

Column	Datatype	Null	Description
`JOB_NAME`	`VARCHAR2(100)`	`NOT NULL`	Name of the audit trail purge job
`JOB_STATUS`	`VARCHAR2(8)`		Current status of the audit trail purge job (`ENABLED`) or (`DISABLED`)
`AUDIT_TRAIL`	`VARCHAR2(28)`		Audit trail for which the audit trail purge job 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`
`JOB_FREQUENCY`	`VARCHAR2(100)`		Frequency at which the audit trail purge job runs

13.4 DBA_AUDIT_MGMT_CLEAN_EVENTS

The DBA_AUDIT_MGMT_CLEAN_EVENTS data dictionary view displays the history of cleanup or purge events.

Column	Datatype	Null	Description
`AUDIT_TRAIL`	`VARCHAR2(28)`		The audit trail that was cleaned at the time of the event: `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`
`RAC_INSTANCE`	`NUMBER`	`NOT NULL`	Instance number indicating the Oracle RAC instance that was cleaned up at the time of the event. 0 implies "Not Applicable".
`CLEANUP_TIME`	`TIMESTAMP(6) WITH TIME ZONE`		Timestamp when the cleanup event completed
`DELETE_COUNT`	`NUMBER`		Number of audit records or audit files that were deleted at the time of the event
`WAS_FORCED`	`VARCHAR2(3)`		Indicates whether a forced cleanup occurred (`YES`) or (`NO`); forced cleanup bypasses the last archive timestamp set