Search notes:

Oracle: X$KGLLK

This table lists all held and requested library object locks for all sessions. It is more complete than v$lock.

The column kglnaobj displays the first 80 characters of the name of the object.

select 
  kglnaobj, kgllkreq
from 
  x$kgllk x join v$session s on 
    s.saddr = x.kgllkses;

kgllkreq = 0 means, the lock is held, while kgllkreq > 0 means that the lock is requested.

See also