V$LOGSTDBY_TRANSACTION definition in Oracle Database 11.2
V$LOGSTDBY_TRANSACTION
select
primary_xidusn, -- PRIMARY_XIDUSN NUMBER
primary_xidslt, -- PRIMARY_XIDSLT NUMBER
primary_xidsqn, -- PRIMARY_XIDSQN NUMBER
primary_xid, -- PRIMARY_XID RAW(8)
primary_start_scn, -- PRIMARY_START_SCN NUMBER
primary_start_time, -- PRIMARY_START_TIME DATE
primary_parent_xidusn, -- PRIMARY_PARENT_XIDUSN NUMBER
primary_parent_xidslt, -- PRIMARY_PARENT_XIDSLT NUMBER
primary_parent_xidsqn, -- PRIMARY_PARENT_XIDSQN NUMBER
primary_parent_xid, -- PRIMARY_PARENT_XID RAW(8)
type, -- TYPE VARCHAR2(32)
mining_status, -- MINING_STATUS VARCHAR2(32)
apply_status, -- APPLY_STATUS VARCHAR2(6)
sid, -- SID NUMBER
serial# -- SERIAL# NUMBER
from
gv$logstdby_transaction
where
inst_id = USERENV('Instance')