eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: SYS.DBA_AUDIT_MGMT_LAST_ARCH_TS

Source

View Text - Preformatted


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$

View Text - HTML Formatted

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$