select
  x.inst_id,                               -- INST_ID NUMBER
  x.kxidusn,                               -- XIDUSN NUMBER
  x.kxidslt,                               -- XIDSLOT NUMBER
  x.kxidsqn,                               -- XIDSQN NUMBER
  l.ktadmtab,                              -- OBJECT_ID NUMBER
  s.indx,                                  -- SESSION_ID NUMBER
  s.ksuudlna,                              -- ORACLE_USERNAME VARCHAR2(30)
  s.ksuseunm,                              -- OS_USER_NAME VARCHAR2(30)
  s.ksusepid,                              -- PROCESS VARCHAR2(24)
  l.ksqlkmod                               -- LOCKED_MODE NUMBER
from
  x$ktcxb x,
  x$ktadm l,
  x$ksuse s
where
  x.ktcxbxba = l.kssobown and x.ktcxbses = s.addr