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_at_singnet.com.sg> 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_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
> -----------------------------------------------------------------
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_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 - 04:11:56 CST