Oracle教程 2023-04-05

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

本站中文解释

Oracle视图DBA_AUDIT_MGMT_CLEANUP_JOBS显示了所有审计自动清理作业的状态。它允许DBA关注审计信息，并控制审计信息的清理，以避免占用太多的空间。该视图具有以下列：

– JOB_NAME：可以使用此列获取审计自动清理作业的名称。

– JOB_ACTIVE：布尔值，指示该作业是否正在运行。

– NEXT_EXECUTION_DATE：下次运行作业的日期和时间

– COUNTY：该审计自动清理作业的执行频率的次数。

要使用这个视图，首先要执行以下步骤，以便在Oracle中根据审计记录设置自动清理作业：

1.使用Oracle的AUDIT_MGMT_JOBS包，创建审计管理作业。

2.在审计自动清理作业中设置应执行的操作类型和频率和时间。

3.执行以下查询，其中”JOB_NAME”为审计自动清理作业的名称：SELECT * from DBA_AUDIT_MGMT_CLEANUP_JOBS WHERE JOB_NAME = ‘JOB_NAME’;

4.如果需要，可以修改或停止审计自动清理作业，以更新状态。

5.使用相同的查询，检查更新的状态，确保作业正常运行。

官方英文解释

DBA_AUDIT_MGMT_CLEANUP_JOBS displays information about the configured audit trail purge jobs.

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
`JOB_NAME`	`VARCHAR2(100)`	`NOT NULL`	Name of the audit trail purge job
`JOB_STATUS`	`VARCHAR2(8)`		Current status of the audit trail purge job (`ENABLED`) or (`DISABLED`)
`AUDIT_TRAIL`	`VARCHAR2(28)`		Audit trail for which the audit trail purge job is configured: `STANDARD AUDIT TRAIL` `FGA AUDIT TRAIL` `STANDARD AND FGA AUDIT TRAIL` `OS AUDIT TRAIL` `XML AUDIT TRAIL` `OS AND XML AUDIT TRAIL` `ALL AUDIT TRAILS` `UNIFIED AUDIT TRAIL`
`JOB_FREQUENCY`	`VARCHAR2(100)`		Frequency at which the audit trail purge job runs
`USE_LAST_ARCHIVE_TIMESTAMP`	`VARCHAR2(3)`		Indicates whether the audit trail purge job invocation uses the last archive timestamp. The last archive timestamp is shown in the `LAST_ARCHIVE_TS` column of the `DBA_AUDIT_MGMT_LAST_ARCH_TS` view. Possible values: `YES` – Indicates that the audit trail purge job invocation uses the last archive timestamp `NO` – Indicates that the audit trail purge job invocation does not use the last archive timestamp
`JOB_CONTAINER`	`VARCHAR2(7)`		In a CDB, indicates whether audit trail purge job will be performed only in the current container or in all the containers. Possible values: `CURRENT` – Indicates that audit trail purge job will be performed only in the current container `ALL` – Indicates that audit trail purge job will be performed in all the containers In a non-CDB, the value in this column is always `CURRENT`.

本站中文解释

官方英文解释

相关推荐