GV$LOGMNR_TRANSACTION

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
home |  up  |  mailbox