Hi
All
I
have a session which is waiting for Library Cache latch for 6 hours. How can I
find who is holding this latch.
This session is
executing a pl/sql script ( Not package ). Latch# 60 is library cache
latch.
<SPAN
class=696130415-15022002>
<SPAN
class=696130415-15022002>
Here is from
v$session_wait
<SPAN
class=696130415-15022002>
1
select * from v$session_wait 2* where sid=1005PROD>/Press
Enter to Continue ....
SID SEQ#
EVENT
P1TEXT
------- ----------- ------------------------------
-------------------------------------------------P1RAW
P2TEXT
P2 P2RAW----------------
---------------------------------------------------------------- -----------
------
Wait Sec
inP3TEXT
P3
P3RAW
time Wait
STATE----------------------------------------------------------------
----------- ---------------- ------
1005 5987 latch
free
address
@992507000001C0A5E228
number
60
000000000000003Ctries
0
00
-1 32,962 WAITED SHORT
<SPAN
class=696130415-15022002>
<SPAN
class=696130415-15022002>
<SPAN
class=696130415-15022002>
<SPAN
class=696130415-15022002>Thanks
<SPAN
class=696130415-15022002>
<FONT face=Arial color=#000080
size=2>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Brijesh
Gupta
Oracle Production DBA
Received on Fri Feb 15 2002 - 10:13:11 CST
