VIEW: SYS.DBA_LOGSTDBY_HISTORY

Source

View Text - Preformatted

select stream_sequence#, decode(status, 1, 'Past', 2, 'Immediate Past', 3,
         'Current', 4, 'Immediate Future', 5, 'Future', 6, 'Canceled', 7,
         'Invalid') status, decode(source, 1, 'Rfs', 2, 'User', 3, 'Synch', 4,
         'Redo') source, dbid, first_change#, last_change#, first_time,
         last_time, dgname, spare1 merge_change#, spare2 processed_change#
  from system.logstdby$history

View Text - HTML Formatted

SELECT STREAM_SEQUENCE#
, DECODE(STATUS
, 1
, 'PAST'
, 2
, 'IMMEDIATE PAST'
, 3
, 'CURRENT'
, 4
, 'IMMEDIATE FUTURE'
, 5
, 'FUTURE'
, 6
, 'CANCELED'
, 7
, 'INVALID') STATUS
, DECODE(SOURCE
, 1
, 'RFS'
, 2
, 'USER'
, 3
, 'SYNCH'
, 4
, 'REDO') SOURCE
, DBID
, FIRST_CHANGE#
, LAST_CHANGE#
, FIRST_TIME
, LAST_TIME
, DGNAME
, SPARE1 MERGE_CHANGE#
, SPARE2 PROCESSED_CHANGE#
FROM SYSTEM.LOGSTDBY$HISTORY