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.

[Home] [Help]

VIEW: SYS.DBA_REDO_DB

Source

View Text - Preformatted


SELECT
    S.DBID                 DBID,
    S.GLOBAL_DBNAME        GLOBAL_DBNAME,
    S.DBUNAME              DBUNAME,
    S.VERSION              VERSION,
    S.THREAD#              THREAD#,
    S.RESETLOGS_SCN        RESETLOGS_SCN,
    S.RESETLOGS_TIME       RESETLOGS_TIME,
    S.PRESETLOGS_SCN       PRESETLOGS_SCN,
    S.PRESETLOGS_TIME      PRESETLOGS_TIME,
    S.SEQNO_RCV_CUR        SEQNO_RCV_CUR,
    S.SEQNO_RCV_LO         SEQNO_RCV_LO,
    S.SEQNO_RCV_HI         SEQNO_RCV_HI,
    S.SEQNO_DONE_CUR       SEQNO_DONE_CUR,
    S.SEQNO_DONE_LO        SEQNO_DONE_LO,
    S.SEQNO_DONE_HI        SEQNO_DONE_HI,
    S.GAP_SEQNO            GAP_SEQNO,
    S.GAP_NEXT_SCN         GAP_NEXT_SCN,
    S.GAP_NEXT_TIME        GAP_NEXT_TIME,
    S.GAP_RET              GAP_RET,
    S.GAP_DONE             GAP_DONE,
    S.APPLY_SEQNO          APPLY_SEQNO,
    S.APPLY_DONE           APPLY_DONE,
    S.PURGE_DONE           PURGE_DONE,
    S.HAS_CHILD            HAS_CHILD,
    S.ERROR1               ERROR1,
    S.STATUS               STATUS,
    S.CREATE_DATE          CREATE_DATE,
    S.TS1                  TS1,
    S.TS2                  TS2,
    S.TS3                  TS3,
    S.GAP_RET2             GAP_RET2,
    S.CURLOG               CURLOG,
    S.ENDIAN               ENDIAN,
    S.ENQIDX               ENQIDX
  FROM SYSTEM.REDO_DB S

View Text - HTML Formatted

SELECT S.DBID DBID
, S.GLOBAL_DBNAME GLOBAL_DBNAME
, S.DBUNAME DBUNAME
, S.VERSION VERSION
, S.THREAD# THREAD#
, S.RESETLOGS_SCN RESETLOGS_SCN
, S.RESETLOGS_TIME RESETLOGS_TIME
, S.PRESETLOGS_SCN PRESETLOGS_SCN
, S.PRESETLOGS_TIME PRESETLOGS_TIME
, S.SEQNO_RCV_CUR SEQNO_RCV_CUR
, S.SEQNO_RCV_LO SEQNO_RCV_LO
, S.SEQNO_RCV_HI SEQNO_RCV_HI
, S.SEQNO_DONE_CUR SEQNO_DONE_CUR
, S.SEQNO_DONE_LO SEQNO_DONE_LO
, S.SEQNO_DONE_HI SEQNO_DONE_HI
, S.GAP_SEQNO GAP_SEQNO
, S.GAP_NEXT_SCN GAP_NEXT_SCN
, S.GAP_NEXT_TIME GAP_NEXT_TIME
, S.GAP_RET GAP_RET
, S.GAP_DONE GAP_DONE
, S.APPLY_SEQNO APPLY_SEQNO
, S.APPLY_DONE APPLY_DONE
, S.PURGE_DONE PURGE_DONE
, S.HAS_CHILD HAS_CHILD
, S.ERROR1 ERROR1
, S.STATUS STATUS
, S.CREATE_DATE CREATE_DATE
, S.TS1 TS1
, S.TS2 TS2
, S.TS3 TS3
, S.GAP_RET2 GAP_RET2
, S.CURLOG CURLOG
, S.ENDIAN ENDIAN
, S.ENQIDX ENQIDX
FROM SYSTEM.REDO_DB S