Skip Headers

Oracle® Audit Vault Administrator's Guide Release 10.2.3 Part Number E11059-03 |
Home | Book List | Contents | Index | Contact Us

Previous | Next
| View PDF

# 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