Library Cache Lock

Links

Frequent Oracle Errors

•	TNS:could not resolve the connect identifier specified
•	Backtrace message unwound by exceptions
•	invalid identifier
•	PL/SQL compilation error
•	internal error
•	missing expression
•	table or view does not exist
•	end-of-file on communication channel
•	TNS:listener unknown in connect descriptor
•	insufficient privileges
•	PL/SQL: numeric or value error string
•	TNS:protocol adapter error
•	ORACLE not available
•	target host or object does not exist
•	invalid number
•	unable to allocate string bytes of shared memory
•	resource busy and acquire with NOWAIT specified
•	error occurred at recursive SQL level string
•	ORACLE initialization or shutdown in progress
•	archiver error. Connect internal only, until freed
•	snapshot too old
•	unable to extend temp segment by string in tablespace
•	Credential retrieval failed
•	missing or invalid option
•	invalid username/password; logon denied
•	unable to create INITIAL extent for segment
•	out of process memory when trying to allocate string bytes
•	shared memory realm does not exist
•	cannot insert NULL
•	TNS:unable to connect to destination
•	remote database not found'>ora-02019
•	exception encountered: core dump
•	inconsistent datatypes
•	no data found
•	TNS:operation timed out
•	PL/SQL: could not find program
•	existing state of packages has been discarded
•	maximum number of processes exceeded
•	error signaled in parallel query server
•	ORACLE instance terminated. Disconnection forced
•	TNS:packet writer failure
•	see ORA-12699
•	missing right parenthesis
•	name is already used by an existing object
•	cannot identify/lock data file
•	invalid file operation
•	quoted string not properly terminated

Library Cache Lock

Library Cache Lock

2004-06-02 - By David Sharples

Reply: 1 2 3 4 5 6 7 8 9 10 >>

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

<html xmlns:v= "urn:schemas-microsoft-com:vml " xmlns:o= "urn:schemas-microsoft-com:office:office " xmlns:w= "urn:schemas-microsoft-com:office:word " xmlns= "http://www.w3.org/TR/REC-html40 " >

<head >
<META HTTP-EQUIV= "Content-Type " CONTENT= "text/html; charset=us-ascii " >
<meta name=Generator content= "Microsoft Word 11 (filtered medium) " >
<!--[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]-- >
<title >library cache lock </title >
<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 lang=EN-US link=blue vlink=purple >

<div class=Section1 >

 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 > 

 <o:p > </o:p > 

<div >

<div class=MsoNormal align=center style= 'text-align:center ' > 

<hr size=2 width= "100% " align=center tabindex=-1 >

 </div >

 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 <o:p > </o:p > 

</div >

 <o:p > </o:p > 

<div >

 The metalink has answers for similar
issues. <o:p > </o:p > 

</div >

<div >

 <o:p > </o:p > 

</div >

<blockquote style= 'margin-top:5.0pt;margin-right:0cm;margin-bottom:5.0pt ' >

 -- --Original Message-- -- 
 From: David Sharples
[mailto:dsharples@(protected)] 
 Sent: Wednesday, June 02, 2004
8:44 AM 
 To: oracle-l@(protected) 
 Subject: library cache lock <o:p > </o:p > 

 <!-- 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 – flushing the shared pool didn’t help and there are no other sessions
touching that table. <o:p > </o:p > 

 Thanks <o:p > </o:p > 

 Dave <o:p > </o:p > 

</blockquote >

</div >

</body >

</html >