Re: Library Cache Lock

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 29 Jan 2004 21:31:52 -0000
Message-ID: <010701c3e6af$5135c710$6702a8c0@Primary>

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_at_hds.com> To: <oracle-l_at_freelists.org> 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_at_freelists.org 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
-----------------------------------------------------------------

Received on Thu Jan 29 2004 - 15:31:52 CST