SELECT
  USN,                                     -- USN NUMBER
  SLT,                                     -- SLT NUMBER
  SEQ,                                     -- SEQ NUMBER
  STATE,                                   -- STATE VARCHAR2(16)
  UNDOBLOCKSDONE,                          -- UNDOBLOCKSDONE NUMBER
  UNDOBLOCKSTOTAL,                         -- UNDOBLOCKSTOTAL NUMBER
  PID,                                     -- PID NUMBER
  CPUTIME,                                 -- CPUTIME NUMBER
  PARENTUSN,                               -- PARENTUSN NUMBER
  PARENTSLT,                               -- PARENTSLT NUMBER
  PARENTSEQ,                               -- PARENTSEQ NUMBER
  XID,                                     -- XID RAW(8)
  PXID,                                    -- PXID RAW(8)
  RCVSERVERS                               -- RCVSERVERS NUMBER
from
  GV$FAST_START_TRANSACTIONS
where
  INST_ID = USERENV('Instance')