VIEW: SYS.DBA_AUDIT_MGMT_CLEAN_EVENTS

Source

View Text - Preformatted

SELECT decode(AUDIT_TRAIL_TYPE#,
              1, 'STANDARD AUDIT TRAIL',
              2, 'FGA AUDIT TRAIL',
              3, 'STANDARD AND FGA AUDIT TRAIL',
              4, 'OS AUDIT TRAIL',
              8, 'XML AUDIT TRAIL',
             12, 'OS AND XML AUDIT TRAIL',
             15, 'ALL AUDIT TRAILS',
             51, 'UNIFIED AUDIT TRAIL',
                 'UNKNOWN AUDIT TRAIL'),
        RAC_INSTANCE#,
        FROM_TZ(CLEANUP_TIME, '0:00'),
        DELETE_COUNT,
        decode(WAS_FORCED,
               0, 'NO',
               1, 'YES',
               null)
FROM DAM_CLEANUP_EVENTS$
ORDER BY SERIAL#

View Text - HTML Formatted

SELECT DECODE(AUDIT_TRAIL_TYPE#
, 1
, 'STANDARD AUDIT TRAIL'
, 2
, 'FGA AUDIT TRAIL'
, 3
, 'STANDARD
AND FGA AUDIT TRAIL'
, 4
, 'OS AUDIT TRAIL'
, 8
, 'XML AUDIT TRAIL'
, 12
, 'OS
AND XML AUDIT TRAIL'
, 15
, 'ALL AUDIT TRAILS'
, 51
, 'UNIFIED AUDIT TRAIL'
, 'UNKNOWN AUDIT TRAIL')
, RAC_INSTANCE#
, FROM_TZ(CLEANUP_TIME
, '0:00')
, DELETE_COUNT
, DECODE(WAS_FORCED
, 0
, 'NO'
, 1
, 'YES'
, NULL) FROM DAM_CLEANUP_EVENTS$ ORDER BY SERIAL#