Re: buffer hit cache ratio

From: Noons <wizofoz2k_at_yahoo.com.au.nospam>
Date: Tue, 23 Dec 2003 20:16:46 +1100
Message-ID: <3fe80871$1$18389$afc38c87@news.optusnet.com.au>

"Tom Brown" <tomNOSPAM_at_teameazyriders.com> wrote in message news:RDJFb.3901$2x.35138735_at_news-text.cableinet.net...
> What is an acceptable hit ratio?

Ask the mob.

> currently i have about 84% and although the performance is fine i'm curious
> if i can make it better?

If the performance is fine and you don't have a ridiculously small buffer cache for the working set size of your db buffers, then leave the darn thing ALONE! It's useless to even try to make it meet a given value in those conditions.

-- 
Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam

Received on Tue Dec 23 2003 - 03:16:46 CST