Oracle 视图 DBA_AUDIT_MGMT_LAST_ARCH_TS 官方解释，作用，如何使用详细说明
本站中文解释
G
Oracle视图DBA_AUDIT_MGMT_LAST_ARCH_TS用于显示系统中每个审计管理审计文件（XMF）最后一次归档的时间点。该视图包含一个叫XML_FILE_NAME的列，该列包含被归档的文件的XML名称；还有一列叫LAST_ARCHIVED_ON，它包含文件最后一次归档的时间，通常以格式DD-MM-YYYY HH24:MI:SS表示。
要使用DBA_AUDIT_MGMT_LAST_ARCH_TS视图，可以使用SELECT子句来检索此视图中的每个XML文件的最后归档时间。例如，下面的SELECT子句将检索系统中名为“AUD$_ORACLE_USER_yyyymmddhh24miss.xml”的审计文件的最后一次归档时间：
SELECT XML_FILE_NAME, LAST_ARCHIVED_ON
FROM DBA_AUDIT_MGMT_LAST_ARCH_TS
WHERE XML_FILE_NAME = ‘AUD$_ORACLE_USER_yyyymmddhh24miss.xml’
ORDER BY LAST_ARCHIVED_ON DESC;
官方英文解释
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
