select
  inst_id,                                 -- INST_ID NUMBER
  ktcxbxba,                                -- ADDR RAW(8)
  kxidusn,                                 -- XIDUSN NUMBER
  kxidslt,                                 -- XIDSLOT NUMBER
  kxidsqn,                                 -- XIDSQN NUMBER
  ktcxbkfn,                                -- UBAFIL NUMBER
  kubablk,                                 -- UBABLK NUMBER
  kubaseq,                                 -- UBASQN NUMBER
  kubarec,                                 -- UBAREC NUMBER
  decode(                                  -- STATUS VARCHAR2(16)
    ktcxbsta,0,'IDLE',1,'COLLECTING',2,'PREPARED',3,'COMMITTED', 4,'HEURISTIC ABORT',5,'HEURISTIC COMMIT', 6,'HEURISTIC DAMAGE',7,'TIMEOUT',9,'INACTIVE', 10,'ACTIVE',11,'PTX PREPARED',12,'PTX COMMITTED', 'UNKNOWN'),
  ktcxbstm,                                -- START_TIME VARCHAR2(20)
  ktcxbssb,                                -- START_SCNB NUMBER
  ktcxbssw,                                -- START_SCNW NUMBER
  ktcxbsen,                                -- START_UEXT NUMBER
  ktcxbsfl,                                -- START_UBAFIL NUMBER
  ktcxbsbk,                                -- START_UBABLK NUMBER
  ktcxbssq,                                -- START_UBASQN NUMBER
  ktcxbsrc,                                -- START_UBAREC NUMBER
  ktcxbses,                                -- SES_ADDR RAW(8)
  ktcxbflg,                                -- FLAG NUMBER
  decode(                                  -- SPACE VARCHAR2(3)
    bitand(ktcxbflg,16),0,'NO','YES'),
  decode(                                  -- RECURSIVE VARCHAR2(3)
    bitand(ktcxbflg,32),0,'NO','YES'),
  decode(                                  -- NOUNDO VARCHAR2(3)
    bitand(ktcxbflg,64),0,'NO','YES'),
  decode(                                  -- PTX VARCHAR2(3)
    bitand(ktcxbflg,8388608),0,'NO','YES'),
  ktcxbnam,                                -- NAME VARCHAR2(256)
  ktcxbpus,                                -- PRV_XIDUSN NUMBER
  ktcxbpsl,                                -- PRV_XIDSLT NUMBER
  ktcxbpsq,                                -- PRV_XIDSQN NUMBER
  ktcxbpxu,                                -- PTX_XIDUSN NUMBER
  ktcxbpxs,                                -- PTX_XIDSLT NUMBER
  ktcxbpxq,                                -- PTX_XIDSQN NUMBER
  ktcxbdsb,                                -- DSCN-B NUMBER
  ktcxbdsw,                                -- DSCN-W NUMBER
  ktcxbubk,                                -- USED_UBLK NUMBER
  ktcxburc,                                -- USED_UREC NUMBER
  ktcxblio,                                -- LOG_IO NUMBER
  ktcxbpio,                                -- PHY_IO NUMBER
  ktcxbcrg,                                -- CR_GET NUMBER
  ktcxbcrc,                                -- CR_CHANGE NUMBER
  to_date(                                 -- START_DATE DATE
    ktcxbstm,'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian'),
  ktcxbdsb,                                -- DSCN_BASE NUMBER
  ktcxbdsw,                                -- DSCN_WRAP NUMBER
  ktcxbssc,                                -- START_SCN NUMBER
  ktcxbdsc,                                -- DEPENDENT_SCN NUMBER
  ktcxbxid,                                -- XID RAW(8)
  ktcxbpid,                                -- PRV_XID RAW(8)
  ktcxbpxi                                 -- PTX_XID RAW(8)
from
  x$ktcxb
where
  bitand(ksspaflg,1)!=0 and bitand(ktcxbflg,2)!=0