Library Cache Lock 2004-06-02 - By Danisment Gazi Unal (ubTools)
library cache lockHi,
See Metalink Note:122793.1. If you need SYSTEMSTATE dump interpretation, let us know.
best regards...
http://www.ubTools.com
Web Based Oracle Products and Services
-- -- Original Message -- --
From: David Sharples
To: oracle-l@(protected)
Sent: Wednesday, June 02, 2004 4:40 PM
Subject: RE: library cache lock
I searched (probably on wrong words) didn 't return anything useful as I could see, can you show me a url?
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- -----
From: oracle-l-bounce@(protected) [mailto:oracle-l-bounce@(protected)] On Behalf Of Khedr, Waleed
Sent: 02 June 2004 14:10
To: oracle-l@(protected)
Subject: RE: library cache lock
The metalink has answers for similar issues.
-- --Original Message-- --
From: David Sharples [mailto:dsharples@(protected)]
Sent: Wednesday, June 02, 2004 8:44 AM
To: oracle-l@(protected)
Subject: library cache lock
Hi, got a strange problem. I am trying to truncate a partition in a table, but it just hangs forever, it is waiting on a library cache lock. Anyone know why and how I can clear it - flushing the shared pool didn 't help and there are no other sessions touching that table.
Thanks
Dave
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN " >
<HTML xmlns= "http://www.w3.org/TR/REC-html40 " xmlns:v =
"urn:schemas-microsoft-com:vml " xmlns:o =
"urn:schemas-microsoft-com:office:office " xmlns:w =
"urn:schemas-microsoft-com:office:word " > <HEAD > <TITLE >library cache lock </TITLE >
<META content= "text/html; charset=iso-8859-1 " http-equiv=Content-Type >
<META content= "MSHTML 5.00.3813.800 " name=GENERATOR > <!--[if !mso] >
<STYLE >v\:* {
BEHAVIOR: url(#default#VML)
}
o\:* {
BEHAVIOR: url(#default#VML)
}
w\:* {
BEHAVIOR: url(#default#VML)
}
.shape {
BEHAVIOR: url(#default#VML)
}
</STYLE >
<![endif]-- >
<STYLE >
<!--
/* Font Definitions */
@(protected)
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family: "Times New Roman ";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
p
{mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family: "Times New Roman ";}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@(protected) Section1
{size:612.0pt 792.0pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.Section1
{page:Section1;}
-- >
</STYLE >
</HEAD >
<BODY bgColor=#ffffff lang=EN-US link=blue vLink=purple >
<DIV > <FONT face=Arial size=2 >Hi, </FONT > </DIV >
<DIV > </DIV >
<DIV > <FONT face=Arial size=2 >See Metalink <!--StartFragment -- > <FONT
face=helvetica >Note:122793.1. If you need SYSTEMSTATE dump interpretation, let
us know. </FONT > </FONT > </DIV >
<DIV > </DIV >
<DIV > <BR >best regards... </DIV >
<DIV > </DIV >
<DIV > <A href= "http://www.ubTools.com " >http://www.ubTools.com </A > <BR >Web Based
Oracle Products and Services <BR > </DIV >
<BLOCKQUOTE
style= "BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px " >
<DIV style= "FONT: 10pt arial " >-- -- Original Message -- -- </DIV >
<DIV
style= "BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black " > <B >From: </B >
<A href= "mailto:dsharples@(protected) "
title=dsharples@(protected) >David Sharples </A > </DIV >
<DIV style= "FONT: 10pt arial " > <B >To: </B > <A
href= "mailto:oracle-l@(protected) "
title=oracle-l@(protected) >oracle-l@(protected) </A > </DIV >
<DIV style= "FONT: 10pt arial " > <B >Sent: </B > Wednesday, June 02, 2004 4:40
PM </DIV >
<DIV style= "FONT: 10pt arial " > <B >Subject: </B > RE: library cache lock </DIV >
<DIV > <BR > </DIV >
<DIV class=Section1 >
<P class=MsoNormal > <FONT color=navy face=Arial size=2 > <SPAN
style= "COLOR: navy; FONT-FAMILY: Arial; FONT-SIZE: 10pt " >I searched (probably
on wrong words) didn’t return anything useful as I could see, can you show me
a url? <o:p > </o:p > </SPAN > </FONT > </P >
<P class=MsoNormal > <FONT color=navy face=Arial size=2 > <SPAN
style= "COLOR: navy; FONT-FAMILY: Arial; FONT-SIZE: 10pt " > <o:p > </o:p > </SPAN > </FONT > </P >
<DIV >
<DIV align=center class=MsoNormal style= "TEXT-ALIGN: center " > <FONT
face= "Times New Roman " size=3 > <SPAN style= "FONT-SIZE: 12pt " >
<HR align=center SIZE=2 tabIndex=-1 width= "100% " >
</SPAN > </FONT > </DIV >
<P class=MsoNormal > <B > <FONT face=Tahoma size=2 > <SPAN
style= "FONT-FAMILY: Tahoma; FONT-SIZE: 10pt; FONT-WEIGHT: bold " >From: </SPAN > </FONT > </B > <FONT
face=Tahoma size=2 > <SPAN style= "FONT-FAMILY: Tahoma; FONT-SIZE: 10pt " > <A
href= "mailto:oracle-l-bounce@(protected) " >oracle-l-bounce@(protected) </A >
[ <A
href= "mailto:oracle-l-bounce@(protected) " >mailto:oracle-l-bounce@(protected) </A >]
<B > <SPAN style= "FONT-WEIGHT: bold " >On Behalf Of </SPAN > </B >Khedr,
Waleed <BR > <B > <SPAN style= "FONT-WEIGHT: bold " >Sent: </SPAN > </B > 02 June 2004
14:10 <BR > <B > <SPAN style= "FONT-WEIGHT: bold " >To: </SPAN > </B > <A
href= "mailto:oracle-l@(protected) " >oracle-l@(protected) </A > <BR > <B > <SPAN
style= "FONT-WEIGHT: bold " >Subject: </SPAN > </B > RE: library cache
lock </SPAN > </FONT > <o:p > </o:p > </P > </DIV >
<P class=MsoNormal > <FONT face= "Times New Roman " size=3 > <SPAN
style= "FONT-SIZE: 12pt " > <o:p > </o:p > </SPAN > </FONT > </P >
<DIV >
<P class=MsoNormal > <FONT color=blue face= "Times New Roman " size=2 > <SPAN
style= "COLOR: blue; FONT-SIZE: 10pt " >The metalink has answers for similar
issues. </SPAN > </FONT > <o:p > </o:p > </P > </DIV >
<DIV >
<P class=MsoNormal > <FONT face= "Times New Roman " size=3 > <SPAN
style= "FONT-SIZE: 12pt " > <o:p > </o:p > </SPAN > </FONT > </P > </DIV >
<BLOCKQUOTE style= "MARGIN-BOTTOM: 5pt; MARGIN-RIGHT: 0cm; MARGIN-TOP: 5pt " >
<P class=MsoNormal style= "MARGIN-BOTTOM: 12pt " > <FONT face=Tahoma
size=2 > <SPAN style= "FONT-FAMILY: Tahoma; FONT-SIZE: 10pt " >-- --Original
Message-- -- <BR > <B > <SPAN style= "FONT-WEIGHT: bold " >From: </SPAN > </B > David
Sharples [mailto:dsharples@(protected)] <BR > <B > <SPAN
style= "FONT-WEIGHT: bold " >Sent: </SPAN > </B > Wednesday, June 02, 2004 8:44
AM <BR > <B > <SPAN style= "FONT-WEIGHT: bold " >To: </SPAN > </B >
oracle-l@(protected) <BR > <B > <SPAN
style= "FONT-WEIGHT: bold " >Subject: </SPAN > </B > library cache
lock </SPAN > </FONT > <o:p > </o:p > </P >
<P > <FONT face=Arial size=2 > <SPAN lang=EN-GB
style= "FONT-FAMILY: Arial; FONT-SIZE: 10pt " > <!-- Converted from text/rtf format -- >Hi,
got a strange problem. I am trying to truncate a partition in a table,
but it just hangs forever, it is waiting on a library cache lock.
Anyone know why and how I can clear it </SPAN > </FONT > <SPAN lang=EN-GB >
</SPAN > <FONT face=Arial size=2 > <SPAN lang=EN-GB
style= "FONT-FAMILY: Arial; FONT-SIZE: 10pt " >– </SPAN > </FONT > <SPAN lang=EN-GB >
</SPAN > <FONT face=Arial size=2 > <SPAN lang=EN-GB
style= "FONT-FAMILY: Arial; FONT-SIZE: 10pt " >flushing the shared
pool </SPAN > </FONT > <SPAN lang=EN-GB > </SPAN > <FONT face=Arial size=2 > <SPAN
lang=EN-GB style= "FONT-FAMILY: Arial; FONT-SIZE: 10pt " >didn’t help and there
are no other sessions touching that table. </SPAN > </FONT > <o:p > </o:p > </P >
<P > <FONT face=Arial size=2 > <SPAN lang=EN-GB
style= "FONT-FAMILY: Arial; FONT-SIZE: 10pt " >Thanks </SPAN > </FONT > <o:p > </o:p > </P >
<P > <FONT face=Arial size=2 > <SPAN lang=EN-GB
style= "FONT-FAMILY: Arial; FONT-SIZE: 10pt " >Dave </SPAN > </FONT > <o:p > </o:p > </P > </BLOCKQUOTE > </DIV > </BLOCKQUOTE > </BODY > </HTML >
|
|
