[Home] [Help] [Dependency Information]
Object Name: | CDB_AUDIT_MGMT_CLEANUP_JOBS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
The view displays the currently configured audit trail purge jobs in all containers
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
JOB_NAME | VARCHAR2 | (100) | Yes | The name of the Audit Trail Purge Job |
JOB_STATUS | VARCHAR2 | (8) | The current status of the Audit Trail Purge Job | |
AUDIT_TRAIL | VARCHAR2 | (28) | The Audit Trail for which the Audit Trail Purge Job is configured | |
JOB_FREQUENCY | VARCHAR2 | (100) | The frequency at which the Audit Trail Purge Job runs | |
USE_LAST_ARCHIVE_TIMESTAMP | VARCHAR2 | (3) | Indicates if cleanup invocation will use Last Archive Timestamp | |
JOB_CONTAINER | VARCHAR2 | (7) | Indicates in which Container cleanup will be performed | |
CON_ID | NUMBER | container id |
Cut, paste (and edit) the following text to query this object:
SELECT JOB_NAME
, JOB_STATUS
, AUDIT_TRAIL
, JOB_FREQUENCY
, USE_LAST_ARCHIVE_TIMESTAMP
, JOB_CONTAINER
, CON_ID
FROM SYS.CDB_AUDIT_MGMT_CLEANUP_JOBS;
SYS.CDB_AUDIT_MGMT_CLEANUP_JOBS does not reference any database object
SYS.CDB_AUDIT_MGMT_CLEANUP_JOBS is referenced by following:
|
|
|