SELECT
  inst_id,                                 -- INST_ID NUMBER
  usn,                                     -- USN NUMBER
  slt,                                     -- SLT NUMBER
  seq,                                     -- SEQ NUMBER
  state,                                   -- STATE VARCHAR2(16)
  wkd,                                     -- UNDOBLOCKSDONE NUMBER
  twk,                                     -- UNDOBLOCKSTOTAL NUMBER
  pid,                                     -- PID NUMBER
  etime,                                   -- CPUTIME NUMBER
  parentusn,                               -- PARENTUSN NUMBER
  parentslt,                               -- PARENTSLT NUMBER
  parentseq,                               -- PARENTSEQ NUMBER
  xid,                                     -- XID RAW(8)
  pxid,                                    -- PXID RAW(8)
  svrs                                     -- RCVSERVERS NUMBER
from
  x$ktprxrt
union all
SELECT
  inst_id,                                 -- INST_ID NUMBER
  usn,                                     -- USN NUMBER
  slt,                                     -- SLT NUMBER
  seq,                                     -- SEQ NUMBER
  state,                                   -- STATE VARCHAR2(16)
  twk-wkl,                                 -- UNDOBLOCKSDONE NUMBER
  twk,                                     -- UNDOBLOCKSTOTAL NUMBER
  NULL,                                    -- PID NUMBER
  etime,                                   -- CPUTIME NUMBER
  NULL,                                    -- PARENTUSN NUMBER
  NULL,                                    -- PARENTSLT NUMBER
  NULL,                                    -- PARENTSEQ NUMBER
  xid,                                     -- XID RAW(8)
  NULL,                                    -- PXID RAW(8)
  svrs                                     -- RCVSERVERS NUMBER
from
  x$kturhist