Oracle 视图 DBA_AUDIT_MGMT_CLEAN_EVENTS 官方解释，作用，如何使用详细说明
本站中文解释
功能
Oracle 视图 DBA_AUDIT_MGMT_CLEAN_EVENTS 是 Oracle 服务器用于维护审计视图（DBA_AUDIT_MGMT_VIEWS 视图）的审计管理表，存储有关维护审计视图的审计事件的信息。
用途：
这个视图主要用于管理审计事件的维护处理，比如：
1. 审计视图是否需要重新创建。
2. 是否需要重新编译对象。
3. 记录事件创建和删除时间。
使用：
DBA_AUDIT_MGMT_CLEAN_EVENTS 视图只能通过 select 语句查看，不允许执行 update 或 insert 语句，因为它是一个 Oracle 自动管理的视图，它的审计事件是系统会自动添加或删除的。例如，下面是查询 DBA_AUDIT_MGMT_CLEAN_EVENTS 的一条示例语句：
select *
from DBA_AUDIT_MGMT_CLEAN_EVENTS;
官方英文解释
DBA_AUDIT_MGMT_CLEAN_EVENTS displays information about the history of audit trail cleanup or purge events.
Periodically, you should delete the contents of this view so that it will not grow too large.
Note:
This view is intended for use with traditional auditing (pre-Oracle Database 12c auditing) only, not for unified auditing.
-
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 that was cleaned at the time of the event:
|
|
|
|
|
|
Instance number indicating the Oracle RAC instance that was cleaned up at the time of the event; |
|
|
|
Timestamp when the cleanup event completed |
|
|
|
|
Number of audit records or audit files that were deleted at the time of the event |
|
|
|
|
Indicates whether a forced cleanup occurred ( |
Note:
In a read-only database, including an Oracle Active Data Guard physical standby database, this view is not populated. Instead, a summary of cleanup events is written to the respective database instance’s alert log file.
