GV$LOGSTDBY_TRANSACTION

select
lt.inst_id,              -- INST_ID NUMBER
lt.xid,                  -- PRIMARY_XID RAW(8)
lt.startscn,             -- PRIMARY_START_SCN NUMBER
lt.starttimestamp,       -- PRIMARY_START_TIME DATE
lt.parentxid,            -- PRIMARY_PARENT_XID RAW(8)
lt.mining_status,        -- MINING_STATUS VARCHAR2(32)
case                     -- APPLY_STATUS VARCHAR2(6)
  when sas.sid is null then 'NONE' else 'ACTIVE' end,
sas.sid,                 -- SID NUMBER
sas.serial#              -- SERIAL# NUMBER
from
x$krvslvs ls,
x$krvxtx lt,
v$streams_apply_server sas 
where
(ls.name = 'LMNR_SID' and ls.value = lt.session_id) and (lt.chunk = 0 and (lt.xidusn != 0 and lt.xidslt != 0 and lt.xidsqn != 0)) and (lt.xidusn = sas.xidusn (+) and lt.xidslt = sas.xidslt (+) and lt.xidsqn = sas.xidsqn (+))
home |  up  |  mailbox