DBA_AUDIT_MGMT_LAST_ARCH_TS

DBA_AUDIT_MGMT_LAST_ARCH_TS displays information about the last archive timestamps set for audit trail cleanup or purges.

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

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

  • UNIFIED 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 TIME ZONE

 

Timestamp of the last audit record or audit file that has been archived

DATABASE_ID

NUMBER

NOT NULL

Database ID of the audit records to clean up

CONTAINER_GUID1

VARCHAR2(33)

NOT NULL

GUID of the container of the audit records to clean up


Note:

In a read-only database, including an Oracle Active Data Guard physical standby database, this view is not populated when DBMS_AUDIT_MGMT.SET_LAST_ARCHIVE_TIMESTAMP is invoked. In such a case, use DBMS_AUDIT_MGMT.GET_LAST_ARCHIVE_TIMESTAMP to check for the timestamp, if it was configured for the database instance.

See Also:

Oracle Database PL/SQL Packages and Types Reference for more information about DBMS_AUDIT_MGMT subprograms

1

This column is available starting with Oracle Database 12c Release 1 (12.1.0.2).