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(+))

home |  up