I am on 8.1.7.2 Steve Adams's kgl_bucket_count script has come up with a recommended value of 6 but I will run a few iterations to validate it. Unfortunately, I will be getting an opportunity to change _kgl_latch_count and _kgl_bucket_count only once in 2 months. Hemant At 02:11 AM 12-02-04 -0800, you wrote: >Hemant: > >You didn't mention the version. From 9.2 and above level 3 dumps the >statistics and hash table summary. In earlier versions it dumps some >more details about the objects pinned in the lib cache. > >Your understanding is right about the latch distribution. But you need >to see the number of buckets (_kgl_bucket_count) and the distribution >of library cache to confirm the busyness (!) of the child latches. > >Regards, >Gopal > > >--- Hemant K Chitale <hkchital@xxxxxxxxxxxxxx> 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 > > ----------------------------------------------------------------- > > >===== >Have a nice day !! >------------------------------------------------------------ >Best Regards, >K Gopalakrishnan, >Bangalore, INDIA. >---------------------------------------------------------------- >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 >----------------------------------------------------------------- Hemant K Chitale Oracle 9i Database Administrator Certified Professional http://hkchital.tripod.com {last updated 24-Jan-04} ---------------------------------------------------------------- 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 -----------------------------------------------------------------