Re: Latch contention: cache buffer handle

Cache buffer handles are used, I believe, when pinning buffer headers.

However, giving us a 'miss ratio' tells
us nothing. What are the values for
gets and misses, and how do these
compare with the values for gets and
misses on the 'cache buffers chains'
latch.

It is highly likely that you have a
meaningless ratio, and not a
problem.

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Author of:
Practical Oracle 8i: Building Efficient Databases

Screen saver or Life saver: http://www.ud.com
Use spare CPU to assist in cancer research.

Chuck wrote in message <9tdpnp$202sm$1_at_ID-85580.news.dfncis.de>...


>-----BEGIN PGP SIGNED MESSAGE-----

>Hash: SHA1

>

>I am seeing contention on this latch but can't find any documentation

>(am I surprised?) on it. The miss ratio is running 2-3% on it. Can

>anyone offer an explanation as to exactly what this latch is and how

>to reduce contention on it? I've already tried looking in the Oracle

>manuals and Metalink and came up with nothing.

>

>-----BEGIN PGP SIGNATURE-----

>Version: PGPfreeware 7.0.3 for non-commercial use <http://www.pgp.com>

>

>iQA/AwUBO/pqWGm5A4kkb4ZsEQIYQwCgqzPURnhC3m8MC52i+Wp0hLD7QzcAn2D2

>IbPgVNB71PPUVYoJ3ugrbYDY

>=2GeT

>-----END PGP SIGNATURE-----

>

>

>