select
  USERENV('Instance'),                     -- INST_ID NUMBER
  laddr,                                   -- LADDR RAW(8)
  kaddr,                                   -- KADDR RAW(8)
  saddr,                                   -- SADDR RAW(8)
  raddr,                                   -- RADDR RAW(8)
  lmode,                                   -- LMODE NUMBER
  request,                                 -- REQUEST NUMBER
  ctime,                                   -- CTIME NUMBER
  block                                    -- BLOCK NUMBER
from
  v$_lock1
union all
select
  inst_id,                                 -- INST_ID NUMBER
  addr,                                    -- LADDR RAW(8)
  ksqlkadr,                                -- KADDR RAW(8)
  ksqlkses,                                -- SADDR RAW(8)
  ksqlkres,                                -- RADDR RAW(8)
  ksqlkmod,                                -- LMODE NUMBER
  ksqlkreq,                                -- REQUEST NUMBER
  ksqlkctim,                               -- CTIME NUMBER
  ksqlklblk                                -- BLOCK NUMBER
from
  x$ktadm
where
  bitand(kssobflg,1)!=0 and (ksqlkmod!=0 or ksqlkreq!=0)
union all
select
  inst_id,                                 -- INST_ID NUMBER
  addr,                                    -- LADDR RAW(8)
  ksqlkadr,                                -- KADDR RAW(8)
  ksqlkses,                                -- SADDR RAW(8)
  ksqlkres,                                -- RADDR RAW(8)
  ksqlkmod,                                -- LMODE NUMBER
  ksqlkreq,                                -- REQUEST NUMBER
  ksqlkctim,                               -- CTIME NUMBER
  ksqlklblk                                -- BLOCK NUMBER
from
  x$ktatrfil
where
  bitand(kssobflg,1)!=0 and (ksqlkmod!=0 or ksqlkreq!=0)
union all
select
  inst_id,                                 -- INST_ID NUMBER
  addr,                                    -- LADDR RAW(8)
  ksqlkadr,                                -- KADDR RAW(8)
  ksqlkses,                                -- SADDR RAW(8)
  ksqlkres,                                -- RADDR RAW(8)
  ksqlkmod,                                -- LMODE NUMBER
  ksqlkreq,                                -- REQUEST NUMBER
  ksqlkctim,                               -- CTIME NUMBER
  ksqlklblk                                -- BLOCK NUMBER
from
  x$ktatrfsl
where
  bitand(kssobflg,1)!=0 and (ksqlkmod!=0 or ksqlkreq!=0)
union all
select
  inst_id,                                 -- INST_ID NUMBER
  addr,                                    -- LADDR RAW(8)
  ksqlkadr,                                -- KADDR RAW(8)
  ksqlkses,                                -- SADDR RAW(8)
  ksqlkres,                                -- RADDR RAW(8)
  ksqlkmod,                                -- LMODE NUMBER
  ksqlkreq,                                -- REQUEST NUMBER
  ksqlkctim,                               -- CTIME NUMBER
  ksqlklblk                                -- BLOCK NUMBER
from
  x$ktatl
where
  bitand(kssobflg,1)!=0 and (ksqlkmod!=0 or ksqlkreq!=0)
union all
select
  inst_id,                                 -- INST_ID NUMBER
  addr,                                    -- LADDR RAW(8)
  ksqlkadr,                                -- KADDR RAW(8)
  ksqlkses,                                -- SADDR RAW(8)
  ksqlkres,                                -- RADDR RAW(8)
  ksqlkmod,                                -- LMODE NUMBER
  ksqlkreq,                                -- REQUEST NUMBER
  ksqlkctim,                               -- CTIME NUMBER
  ksqlklblk                                -- BLOCK NUMBER
from
  x$ktstusc
where
  bitand(kssobflg,1)!=0 and (ksqlkmod!=0 or ksqlkreq!=0)
union all
select
  inst_id,                                 -- INST_ID NUMBER
  addr,                                    -- LADDR RAW(8)
  ksqlkadr,                                -- KADDR RAW(8)
  ksqlkses,                                -- SADDR RAW(8)
  ksqlkres,                                -- RADDR RAW(8)
  ksqlkmod,                                -- LMODE NUMBER
  ksqlkreq,                                -- REQUEST NUMBER
  ksqlkctim,                               -- CTIME NUMBER
  ksqlklblk                                -- BLOCK NUMBER
from
  x$ktstuss
where
  bitand(kssobflg,1)!=0 and (ksqlkmod!=0 or ksqlkreq!=0)
union all
select
  inst_id,                                 -- INST_ID NUMBER
  addr,                                    -- LADDR RAW(8)
  ksqlkadr,                                -- KADDR RAW(8)
  ksqlkses,                                -- SADDR RAW(8)
  ksqlkres,                                -- RADDR RAW(8)
  ksqlkmod,                                -- LMODE NUMBER
  ksqlkreq,                                -- REQUEST NUMBER
  ksqlkctim,                               -- CTIME NUMBER
  ksqlklblk                                -- BLOCK NUMBER
from
  x$ktstusg
where
  bitand(kssobflg,1)!=0 and (ksqlkmod!=0 or ksqlkreq!=0)
union all
select
  inst_id,                                 -- INST_ID NUMBER
  ktcxbxba,                                -- LADDR RAW(8)
  ktcxblkp,                                -- KADDR RAW(8)
  ksqlkses,                                -- SADDR RAW(8)
  ksqlkres,                                -- RADDR RAW(8)
  ksqlkmod,                                -- LMODE NUMBER
  ksqlkreq,                                -- REQUEST NUMBER
  ksqlkctim,                               -- CTIME NUMBER
  ksqlklblk                                -- BLOCK NUMBER
from
  x$ktcxb
where
  bitand(ksspaflg,1)!=0 and (ksqlkmod!=0 or ksqlkreq!=0)