SELECT decode(AUDIT_TRAIL_TYPE#,
1, 'STANDARD AUDIT TRAIL',
2, 'FGA AUDIT TRAIL',
4, 'OS AUDIT TRAIL',
8, 'XML AUDIT TRAIL',
51, 'UNIFIED AUDIT TRAIL',
'UNKNOWN AUDIT TRAIL'),
RAC_INSTANCE#,
decode(AUDIT_TRAIL_TYPE#,
1, FROM_TZ(LAST_ARCHIVE_TIMESTAMP, '0:00'),
2, FROM_TZ(LAST_ARCHIVE_TIMESTAMP, '0:00'),
4, FROM_TZ(LAST_ARCHIVE_TIMESTAMP, TZ_OFFSET(sessiontimezone)),
8, FROM_TZ(LAST_ARCHIVE_TIMESTAMP, TZ_OFFSET(sessiontimezone)),
51, FROM_TZ(LAST_ARCHIVE_TIMESTAMP, '0:00'),
LAST_ARCHIVE_TIMESTAMP),
DATABASE_ID,
CONTAINER_GUID
FROM DAM_LAST_ARCH_TS$
SELECT DECODE(AUDIT_TRAIL_TYPE#
,
1
, 'STANDARD AUDIT TRAIL'
,
2
, 'FGA AUDIT TRAIL'
,
4
, 'OS AUDIT TRAIL'
,
8
, 'XML AUDIT TRAIL'
,
51
, 'UNIFIED AUDIT TRAIL'
,
'UNKNOWN AUDIT TRAIL')
,
RAC_INSTANCE#
,
DECODE(AUDIT_TRAIL_TYPE#
,
1
, FROM_TZ(LAST_ARCHIVE_TIMESTAMP
, '0:00')
,
2
, FROM_TZ(LAST_ARCHIVE_TIMESTAMP
, '0:00')
,
4
, FROM_TZ(LAST_ARCHIVE_TIMESTAMP
, TZ_OFFSET(SESSIONTIMEZONE))
,
8
, FROM_TZ(LAST_ARCHIVE_TIMESTAMP
, TZ_OFFSET(SESSIONTIMEZONE))
,
51
, FROM_TZ(LAST_ARCHIVE_TIMESTAMP
, '0:00')
,
LAST_ARCHIVE_TIMESTAMP)
,
DATABASE_ID
,
CONTAINER_GUID
FROM DAM_LAST_ARCH_TS$
|
|
|