Library Cache Lock 2004-03-05 - By Adams, Matthew (GE Consumer & Industrial)
Oracle 9.2.0 on hp-ux 11
An attempt to truncate a table is hanging for a very long
time.
The processes is waiting over and over for 'library cache lock ' for
the same p1 and p2 (handle address and lock address respectively).
Shouldn 't the P2 value (lock_address) map to a KADDR in v$lock?
----
Matt Adams - GE Appliances - matt.adams@(protected)
Don 't ask a man what kind of computer he uses.
If it 's a Macintosh, he 'll tell you.
If not, why embarass him? -- Tom Clancy
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN " >
<HTML >
<HEAD >
<META HTTP-EQUIV= "Content-Type " CONTENT= "text/html; charset=iso-8859-1 " >
<META NAME= "Generator " CONTENT= "MS Exchange Server version 5.5.2655.35 " >
<TITLE >library cache lock </TITLE >
</HEAD >
<BODY >
<P > <FONT SIZE=2 >Oracle 9.2.0 on hp-ux 11 </FONT >
</P >
<P > <FONT SIZE=2 >An attempt to truncate a table is hanging for a very long </FONT >
<BR > <FONT SIZE=2 >time. </FONT >
</P >
<P > <FONT SIZE=2 >The processes is waiting over and over for 'library cache lock ' for </FONT >
<BR > <FONT SIZE=2 >the same p1 and p2 (handle address and lock address respectively). </FONT >
</P >
<P > <FONT SIZE=2 >Shouldn 't the P2 value (lock_address) map to a KADDR in v$lock? </FONT >
</P >
<BR >
<P > <FONT SIZE=2 >---- </FONT >
<BR > <FONT SIZE=2 >Matt Adams - GE Appliances - matt.adams@(protected) </FONT >
<BR > <FONT SIZE=2 >Don 't ask a man what kind of computer he uses. </FONT >
<BR > <FONT SIZE=2 >If it 's a Macintosh, he 'll tell you. </FONT >
<BR > <FONT SIZE=2 >If not, why embarass him? -- Tom Clancy </FONT >
</P >
</BODY >
</HTML >
|
|
