Getting a Library Cache dump

From: Hemant K Chitale <hkchital_at_singnet.com.sg>
Date: Thu, 12 Feb 2004 17:46:10 +0800 (SGT)
Message-ID: <1076579170.402b4b6213b7f@flounder.singnet.com.sg>

I am encountering Library Cache latch contention.

On the 4 CPU server, I have 5 Child latches to the Library Cache Latch. I need to verify if only one particular latch is busier.

Is a "alter session set events 'immediate trace name library_cache level 3';" the right command to dump to a trace file ? The trace file shows multiple entries for "latch=0" to "latch=4"
I did a count on the trace file and got

7528 entries for latch=0
8002 entries for latch=1
8137 entries for latch=2
7926 entries for latch=3
7726 entries for latch=4

Is my interpretation that the latches are equally busy valid ?
Would _kgl_latch_count help ?

Hemant K Chitale
http://hkchital.tripod.com

---

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 Feb 12 2004 - 03:46:10 CST