Database Tuning (MOSC)

MOSC Banner

library cache load lock / object address

edited Feb 3, 2020 4:03AM in Database Tuning (MOSC) 4 commentsAnswered

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';

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center