VIEW: SYS.DBA_LOGSTDBY_LOG

Source

View Text - Preformatted

select thread#, resetlogs_change#, reset_timestamp resetlogs_id, sequence#,
         first_change#, next_change#, first_time, next_time, file_name,
          timestamp, dict_begin, dict_end,
    (case when l.next_change# <= p.read_scn then 'YES'
          when ((bitand(l.contents, 16) = 16) and
                (bitand(l.status, 4) = 0)) then 'FETCHING'
          when ((bitand(l.contents, 16) = 16) and
                (bitand(l.status, 4) = 4)) then 'CORRUPT'
          when l.first_change# < p.applied_scn then 'CURRENT'
          else 'NO' end) applied, blocks, block_size
  from system.logmnr_log$ l, dba_logstdby_progress p
  where session# =
    (select value from system.logstdby$parameters where name = 'LMNR_SID') and
    (flags is NULL or bitand(l.flags,16) = 0)

View Text - HTML Formatted

SELECT THREAD#
, RESETLOGS_CHANGE#
, RESET_TIMESTAMP RESETLOGS_ID
, SEQUENCE#
, FIRST_CHANGE#
, NEXT_CHANGE#
, FIRST_TIME
, NEXT_TIME
, FILE_NAME
, TIMESTAMP
, DICT_BEGIN
, DICT_END
, (CASE WHEN L.NEXT_CHANGE# <= P.READ_SCN THEN 'YES' WHEN ((BITAND(L.CONTENTS
, 16) = 16) AND (BITAND(L.STATUS
, 4) = 0)) THEN 'FETCHING' WHEN ((BITAND(L.CONTENTS
, 16) = 16) AND (BITAND(L.STATUS
, 4) = 4)) THEN 'CORRUPT' WHEN L.FIRST_CHANGE# < P.APPLIED_SCN THEN 'CURRENT' ELSE 'NO' END) APPLIED
, BLOCKS
, BLOCK_SIZE
FROM SYSTEM.LOGMNR_LOG$ L
, DBA_LOGSTDBY_PROGRESS P
WHERE SESSION# = (SELECT VALUE
FROM SYSTEM.LOGSTDBY$PARAMETERS
WHERE NAME = 'LMNR_SID') AND (FLAGS IS NULL OR BITAND(L.FLAGS
, 16) = 0)