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#
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#
|
|
|