hello
I use database 11.2.0.4 on ole 6.5
I have more than 200 sessions waiting on library cache lock...
I'm trying to find locked object
I use the following query...
select distinct kgllkhdl Handle,kgllkreq Request, kglnaobj Object
from x$kgllk where kgllkses in (select saddr from v$session where event= 'library cache lock')
and kgllkreq > 0;
the reult is
0000002BBFD40288 2 83
but I've excepted to find object name but query return just 83
what is 83??