F DBMS_AUDIT_MGMT Data Dictionary Views

This appendix provides important reference information for the DBMS_AUDIT_MGMT data views.

For reference information on the DBMS_AUDIT_MGMT package, see Appendix G.

F.1 DBMS_AUDIT_MGMT Data Views

Table F-1 lists data dictionary views that are provide auditing information. For detailed information about these views, see Oracle Database Reference.

Use these data dictionary views to find information about the audit trail.

Table F-1 Views That Display Information about the Database Audit Trail

View	Description
DBA_AUDIT_MGMT_CONFIG_PARAMS View	Displays the currently configured audit trail properties that are used by the DBMS_AUDIT_MGMT PL/SQL package
DBA_AUDIT_MGMT_LAST_ARCH_TS View	Displays the last archive timestamps that have been set for audit trail cleanup or purges.
DBA_AUDIT_MGMT_CLEANUP_JOBS View	Displays the currently configured audit trail cleanup or purge jobs
DBA_AUDIT_MGMT_CLEAN_EVENTS View	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;

F.1.1 DBA_AUDIT_MGMT_CONFIG_PARAMS

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

Table F-2 DBA_AUDIT_MGMT_CONFIG_PARAMS View

Name	Data Type	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

F.1.2 DBA_AUDIT_MGMT_LAST_ARCH_TS

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

Table F-3 DBA_AUDIT_MGMT_LAST_ARCH_TS View

Name	Data Type	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

F.1.3 DBA_AUDIT_MGMT_CLEANUP_JOBS

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

Table F-4 DBA_AUDIT_MGMT_CLEANUP_JOBS View

Name	Data Type	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

F.1.4 DBA_AUDIT_MGMT_CLEAN_EVENTS

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

Table F-5 DBA_AUDIT_MGMT_CLEAN_EVENTS View

Name	Data Type	Null?	Description
AUDIT_TRAIL	VARCHER2(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