Re: buffer hit cache ratio

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Mon, 22 Dec 2003 22:59:57 +0100
Message-ID: <q6qeuv42grluh43595lu6ggn2eavdi3kef@4ax.com>

On Mon, 22 Dec 2003 21:47:29 GMT, "Tom Brown" <tomNOSPAM_at_teameazyriders.com> wrote:

>What is an acceptable hit ratio?
>
>currently i have about 84% and although the performance is fine i'm curious
>if i can make it better?
>
>thanks
>

Buffer cache hit ratio is a MIPS (Meaningless Indicator of the Performance of the System). If you increase the buffer cache in size you will likely also increase page faulting. So your attempts to increase the BCH might decrease the total performance. If there is no one complaining, stay away from it and leave it unchanged.

--
Sybrand Bakker, Senior Oracle DBA

Received on Mon Dec 22 2003 - 15:59:57 CST