DBA_AUDIT_MGMT_CLEANUP_JOBS

DBA_AUDIT_MGMT_CLEANUP_JOBS displays information about the configured audit trail purge jobs.

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
JOB_FREQUENCY VARCHAR2(100)   Frequency at which the audit trail purge job runs