select
  distinct s.inst_id,                      -- INST_ID NUMBER
  s.ksusenum,                              -- SID NUMBER
  o.kglnaown,                              -- OWNER VARCHAR2(64)
  o.kglnaobj,                              -- OBJECT VARCHAR2(1000)
  o.kglobtyd                               -- TYPE VARCHAR2(64)
from
  x$ksuse s,
  x$kglob o,
  x$kgldp d,
  x$kgllk l
where
  l.kgllkuse=s.addr and l.kgllkhdl=d.kglhdadr and l.kglnahsh=d.kglnahsh and o.kglnahsh=d.kglrfhsh and o.kglhdadr=d.kglrfhdl