[Home] [Help] [Dependency Information]
Object Name: | DAM_CLEANUP_EVENTS$ |
---|---|
Object Type: | TABLE |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
The history of Audit Trail cleanup events
Tablespace: | SYSTEM |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
SYS_C00236377 | NORMAL | UNIQUE | SYSTEM | SERIAL# |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SERIAL# | NUMBER | Yes | A serial number associated with the cleanup event | |
AUDIT_TRAIL_TYPE# | NUMBER | Yes | The Audit Trail Type which was cleaned during the event | |
RAC_INSTANCE# | NUMBER | Yes | The RAC instance number which was cleaned during the event | |
CLEANUP_TIME | TIMESTAMP(6) | (11) | Yes | The timestamp when the cleanup event completed |
DELETE_COUNT | NUMBER | The number of audit records/files that was cleaned up during the event | ||
WAS_FORCED | NUMBER | Was the cleanup done without considering Last Archive Timestamp |
Cut, paste (and edit) the following text to query this object:
SELECT SERIAL#
, AUDIT_TRAIL_TYPE#
, RAC_INSTANCE#
, CLEANUP_TIME
, DELETE_COUNT
, WAS_FORCED
FROM SYS.DAM_CLEANUP_EVENTS$;
SYS.DAM_CLEANUP_EVENTS$ does not reference any database object
SYS.DAM_CLEANUP_EVENTS$ is referenced by following:
|
|
|