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
编辑：一起学习网
标签：视图,文件,时间,子句,英文