select
  inst_id,                                 -- INST_ID NUMBER
  session_id,                              -- SESSION_ID NUMBER
  xid,                                     -- XID RAW(8)
  xidusn,                                  -- XIDUSN NUMBER
  xidslt,                                  -- XIDSLT NUMBER
  xidsqn,                                  -- XIDSQN NUMBER
  parentxid,                               -- PARENT_XID RAW(8)
  parent_xidusn,                           -- PARENT_XIDUSN NUMBER
  parent_xidslt,                           -- PARENT_XIDSLT NUMBER
  parent_xidsqn,                           -- PARENT_XIDSQN NUMBER
  starttimestamp,                          -- START_TIME DATE
  startscn,                                -- START_SCN NUMBER
  chunk,                                   -- CHUNK# NUMBER
  totalchunks,                             -- TOTAL_CHUNKS NUMBER
  redothread,                              -- REDO_THREAD NUMBER
  lowts,                                   -- LOW_TIME DATE
  lowscn,                                  -- LOW_SCN NUMBER
  committimestamp,                         -- HIGH_TIME DATE
  commitscn,                               -- HIGH_SCN NUMBER
  numchangerecord,                         -- LCR_COUNT NUMBER
  numlcrspilled,                           -- 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
  x$krvxtx