VIEW: SYS.LOGSTDBY_LOG

Source

View Text - Preformatted

select first_change#, next_change#, sequence#, thread#,
         first_time, next_time
  from system.logmnr_log$ where session# =
     (select value from system.logstdby$parameters where name = 'LMNR_SID')
    /* comment */
 union
  select first_change#, (last_change# + 1) next_change#, sequence#, thread#,
         first_time, last_time next_time
  from v$standby_log where status = 'ACTIVE'

View Text - HTML Formatted

SELECT FIRST_CHANGE#
, NEXT_CHANGE#
, SEQUENCE#
, THREAD#
, FIRST_TIME
, NEXT_TIME
FROM SYSTEM.LOGMNR_LOG$
WHERE SESSION# = (SELECT VALUE
FROM SYSTEM.LOGSTDBY$PARAMETERS
WHERE NAME = 'LMNR_SID') /* COMMENT */ UNION SELECT FIRST_CHANGE#
, (LAST_CHANGE# + 1) NEXT_CHANGE#
, SEQUENCE#
, THREAD#
, FIRST_TIME
, LAST_TIME NEXT_TIME
FROM V$STANDBY_LOG
WHERE STATUS = 'ACTIVE'