library cache load lock / object address
we have inserts that waits on library cache load lock. the sql has 40 child cursors so we are pretty sure that this is caused by non-sharable child cursors. my question is how to find out which object the load lock is for. From Doc ID 444560.1, p1 is Address of the object being loaded. p2 is Address of load lock being used. How do I relate the object address to the actual database object? I tried
SQL> select '0' || trim(to_char(54283843192,'XXXXXXXXXXXXXXXXX')) "p1raw" from dual;
p1raw
-------------------
0CA391B678
SQL> SELECT kglnaown AS owner, kglnaobj as Object FROM sys.x$kglob WHERE kglhdadr='0CA391B678';