Re: redo copy latch bad hit ratio

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sat, 26 Jun 1999 10:45:12 +0100
Message-ID: <930390548.22717.0.nnrp-13.9e984b29@news.demon.co.uk>

Can you confirm that you are looking at the

hit_ratio
and not the

nowait_hit_ratio

The former is almost certainly irrelevant for the redo copy latch. You should find that the actual number of gets on this latch in 'willing to wait' mode is very small compared to the get in 'no wait' mode.

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Doug Cowles wrote in message <377406E8.EB2D13C8_at_bigfoot.com>...
>Got .41 for redo copy latch hit ratio in BSTAT/ESTAT.
>Any suggestions? (Or details on what happens with this latch?)
>
>- Dc.
>
Received on Sat Jun 26 1999 - 04:45:12 CDT