GV$LOGSTDBY_TRANSACTION definition in Oracle Database 11.2
GV$LOGSTDBY_TRANSACTION
select
lt.inst_id, -- INST_ID NUMBER
lt.xidusn, -- PRIMARY_XIDUSN NUMBER
lt.xidslt, -- PRIMARY_XIDSLT NUMBER
lt.xidsqn, -- PRIMARY_XIDSQN NUMBER
lt.xid, -- PRIMARY_XID RAW(8)
lt.startscn, -- PRIMARY_START_SCN NUMBER
lt.starttimestamp, -- PRIMARY_START_TIME DATE
lt.parent_xidusn, -- PRIMARY_PARENT_XIDUSN NUMBER
lt.parent_xidslt, -- PRIMARY_PARENT_XIDSLT NUMBER
lt.parent_xidsqn, -- PRIMARY_PARENT_XIDSQN NUMBER
lt.parentxid, -- PRIMARY_PARENT_XID RAW(8)
lt.type, -- TYPE VARCHAR2(32)
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 = 'logminer session id' and ls.value = lt.session_id) and (lt.chunk = 0 and not (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(+))