Re: Library Cache Lock

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@xxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
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@xxxxxxxxxxxxx
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
-----------------------------------------------------------------

Other related posts: