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')

home |  up