4.116 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.
-
See Oracle Database Security Guide for more information about unified auditing.
-
See Oracle Database Upgrade Guide for more information about migrating to unified auditing.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Audit trail for which the last archive timestamp applies:
|
|
|
|
Oracle RAC instance number for which the last archive timestamp applies; |
|
|
|
Timestamp of the last audit record or audit file that has been archived |
|
|
|
Database ID of the audit records to clean up |
|
|
|
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