library cache load lock

I want to find the object that cause an "library cache load lock" event on v$session_wait.

How do you use the "object address" in the event (p2raw) to find the command or object that cause the event?

LVL 1
SantunesAsked:
Who is Participating?
 
UsamaMunirConnect With a Mentor Commented:
The wait parameters of library cache lock & pin waits

are
p1 The address in the memory of the libraray cache handle

p2 The memory address of the lock and pin structure

p3 is encoded as 10*mode+namespace
                  mode = 3 shared, 5 exclusive
                  The namespaces are
                  0 cursor
                  1 Table, procedure & others
                  2 package body
                  3 trigger
                  4 index
                  5 cluster
                  6 object
                  7 pipe

i am looking into how can u get the exact name of the Object, lets see..watching and learning

Peace
UsamaMunir        
0
 
waynezhuConnect With a Mentor Commented:

The X$KGLLK maybe what you need.

Pay special attention to the columns:

KGLLKADR
KGLLKSES
KGLLKHDL
USER_NAME
KGLNAOBJ

where KGLLKHDL is the handle address (
or in another word object address) which
is related to the p1/p1raw; KGLLKADR may
be related to lock address p2/p2raw (I
am not sure on this); KGLNAOBJ is
the name of the state object; KGLLKSES
can be joined with SADDR of V$SESSION.

You may try the following for more information:

Join v$session and v$session_wait to find the
session of your interest, and
"select * from v$kgllk" for the session(s).

Do more research as necessary.

Good luck.

0
 
jpkempCommented:
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
Split between UsamaMunir & waynezhu
Please leave any comments here within the next seven days.
 
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
 
jpkemp
EE Cleanup Volunteer
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.