Oracle教程 2023-02-24

Oracle 视图 V$ASM_AUDIT_CLEANUP_JOBS 官方解释，作用，如何使用详细说明

本站中文解释

Oracle ASM 审计清洁作业视图(V$ASM_AUDIT_CLEANUP_JOBS)显示Oracle Automatic Storage Management(ASM)实例中正在服务的审计清洁作业。

V$ASM_AUDIT_CLEANUP_JOBS包括以下列：

JOB_NAME：审计清洁作业的名称;
START_SCN：要清理审计文件的开始 SCN;
END_SCN：要清理审计文件的结束 SCN;
END_TIME：审计清理作业结束的时间;
STATUS：审计清理作业的状态;
ERROR：错误消息，如果审计清理作业遇到错误。

使用方法：可以使用V$ASM_AUDIT_CLEANUP_JOBS视图来检查正在进行的审计清洁作业，以及审计文件的开始和结束SCN。该视图还可以用来排查审计清洁作业的失败原因，如果有错误消息记录在ERROR列中。

官方英文解释

In an Oracle Automatic Storage Management (Oracle ASM) instance, V$ASM_AUDIT_CLEANUP_JOBS displays information about the configured audit trail purge jobs.

In a database instance, V$ASM_AUDIT_CLEANUP_JOBS displays no rows.

Column	Datatype	Description
`JOB_NAME`	`VARCHAR2(64)`	Name of the audit trail purge job
`JOB_STATUS`	`VARCHAR2(64)`	Current status of the audit trail purge job (`ENABLED`) or (`DISABLED`)
`AUDIT_TRAIL`	`VARCHAR2(64)`	Audit trail for which the audit trail purge job is configured: `OS AUDIT TRAIL` and `UNIFIED AUDIT TRAIL`
`JOB_FREQUENCY`	`NUMBER`	Frequency at which the audit trail purge job runs
`USE_TIMESTAMP`	`VARCHAR2(64)`	Indicates whether the audit trail purge job is configured to use the last archive timestamp (`TRUE`) or not (`FALSE`)
`CON_ID`	`NUMBER`	The ID of the container to which the data pertains. Possible values include: `0`: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs. `1`: This value is used for rows containing data that pertain to only the root n: Where n is the applicable container ID for the rows containing data For this view, the value is always `0`.

本站中文解释

官方英文解释

相关推荐