Home
All Oracle Error Codes
Oracle DBA Forum

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

Re: Library Cache Lock

Jonathan Lewis

2004-01-29

Replies:

John,

Thanks for the note - I think it may have been
your bug that I found on metalink; your description
sounds familiar.

I'm hoping that I get called back to the site, as
it's hard to find interesting problems with things
like the library cache - but at present I'm following
it up for curiosity, rather than necessary.

If I get another shot at the site, I'll get back to you
if I find anything interesting.


Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

The educated person is not the person
who can answer the questions, but the
person who can question the answers -- T. Schick Jr


Next public appearances:
Jan 29th 2004 UKOUG Unix SIG - v$ and x$
March 2004 Hotsos Symposium - The Burden of Proof
March 2004 Charlotte NC OUG - CBO Tutorial
April 2004 Iceland


One-day tutorials:
http://www.jlcomp.demon.co.uk/tutorial.html


Three-day seminar:
see http://www.jlcomp.demon.co.uk/seminar.html
____UK___February
____UK___June


The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html


----- Original Message -----
From: "John Kanagaraj" <john.kanagaraj@(protected)>
To: <oracle-l@(protected)>
Sent: Thursday, January 29, 2004 8:50 PM
Subject: RE: Library Cache Lock


Jonathan,

We have had many similar situations where we had lib cache locks/pins on a
_table_ - did you notice that all the waiters were queueing up behind
another session that was 'hanging' on a 'row cache lock'? (for this happened
consistently in our siutation). This is a fairly large Oracle Apps 11.5.7
installation - this occurred in a schema that has a number of partitioned
tables and MVs. It is possible that there were partial refreshes of the MVs
occurring at the time of the problem.

In any case, we had a large reduction in the occurrences when we upgraded
from 8.1.7.3 to 8.1.7.4, and obtained another reduction when we re-arranged
and serialized some background jobs (Apps concurrent managers). A TAR with
Oracle was useless - we were sent on a runaround and passed from one to
another until we dropped the issue (since the pain went away). I did take
some system dumps, but they might have been purged (I can dig around).

John Kanagaraj
DB Soft Inc
Phone: 408-970-7002 (W)

Disappointment is inevitable, but Discouragement is optional!

** The opinions and facts contained in this message are entirely mine and do
not reflect those of my employer or customers **



----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@(protected)
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------