Skip Headers

Oracle® Audit Vault Administrator's Guide Release 10.2.3.1 Part Number E13841-02 |
Home | Book List | Contents | Index | Contact Us

Previous | Next
| View PDF

# 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