select
  session_id,                              -- SESSION_ID NUMBER
  xid,                                     -- XID RAW(8)
  xidusn,                                  -- XIDUSN NUMBER
  xidslt,                                  -- XIDSLT NUMBER
  xidsqn,                                  -- XIDSQN NUMBER
  parent_xid,                              -- PARENT_XID RAW(8)
  parent_xidusn,                           -- PARENT_XIDUSN NUMBER
  parent_xidslt,                           -- PARENT_XIDSLT NUMBER
  parent_xidsqn,                           -- PARENT_XIDSQN NUMBER
  start_time,                              -- START_TIME DATE
  start_scn,                               -- START_SCN NUMBER
  chunk#,                                  -- CHUNK# NUMBER
  total_chunks,                            -- TOTAL_CHUNKS NUMBER
  redo_thread,                             -- REDO_THREAD NUMBER
  low_time,                                -- LOW_TIME DATE
  low_scn,                                 -- LOW_SCN NUMBER
  high_time,                               -- HIGH_TIME DATE
  high_scn,                                -- HIGH_SCN NUMBER
  lcr_count,                               -- LCR_COUNT NUMBER
  spilled_lcr_count,                       -- SPILLED_LCR_COUNT NUMBER
  dflag,                                   -- DFLAG NUMBER
  mflag,                                   -- MFLAG NUMBER
  mflag2,                                  -- MFLAG2 NUMBER
  state,                                   -- STATE VARCHAR2(32)
  type,                                    -- TYPE VARCHAR2(32)
  mining_status,                           -- MINING_STATUS VARCHAR2(32)
  queue                                    -- QUEUE VARCHAR2(32)
from
  gv$logmnr_transaction
where
  inst_id = userenv('instance')