With the library cache, you can see object structures with the level 4, which means that if you want to see _kgl structures, you need to do something like: ORADEBUG DUMP LIBRARY_CACHE 4 On 02/12/2004 04:46:10 AM, Hemant K Chitale wrote: > > 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@xxxxxxxxxxxxx > put 'unsubscribe' in the subject line. > -- > Archives are at //www.freelists.org/archives/oracle-l/ > FAQ is at //www.freelists.org/help/fom-serve/cache/1.html > ----------------------------------------------------------------- > ---------------------------------------------------------------- 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 //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------