dba_kgllock

select
-- lck.kgllkuse,
   ses.sid, ses.serial#,
   ses.username,
   lck.kgllkhdl,   -- Address of handle for KGL object
   lck.kgllkmod,   -- Current mode
   lck.kgllkreq,   -- Mode or request
   lck.kgllktype   -- Lock or Spin?
from
   dba_kgllock   lck                            left join
   v$session     ses on lck.kgllkuse = ses.saddr  
;