Skip Headers
Oracle® Database Reference
12c Release 1 (12.1)

E41527-09
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

DBA_AUDIT_MGMT_CLEAN_EVENTS

DBA_AUDIT_MGMT_CLEAN_EVENTS displays information about the history of audit trail cleanup or purge events. Periodically, you should delete the contents of this view so that it will not grow too large.

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.
Column Datatype NULL Description
AUDIT_TRAIL VARCHAR2(28)   Audit trail that was cleaned at the time of the event:
  • 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

RAC_INSTANCE NUMBER NOT NULL Instance number indicating the Oracle RAC instance that was cleaned up at the time of the event; 0 implies not applicable
CLEANUP_TIME TIMESTAMP(6) WITH TIME ZONE   Timestamp when the cleanup event completed
DELETE_COUNT NUMBER   Number of audit records or audit files that were deleted at the time of the event
WAS_FORCED VARCHAR2(3)   Indicates whether a forced cleanup occurred (YES) or not (NO); forced cleanup bypasses the last archive timestamp set

Note:

In a read-only database, including an Oracle Active Data Guard physical standby database, this view is not populated. Instead, a summary of cleanup events is written to the respective database instance's alert log file.