Re: buffer hit cache ratio should be ...

From: Frank van Bortel <fbortel_at_nescape.net>
Date: Tue, 23 Dec 2003 23:13:00 +0100
Message-ID: <bsae44$8t5$1@news2.tilbu1.nb.home.nl>

Tom Brown 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
>
>

Ok - I'll throw in one, after all the (valid) comments made: between 50 and 100%
Oh? you want an Xmas bonus, and want to know when? It depends:

- on the type of system (OLTP, DW, DSS)
- on what problems YOU have (selling your earnings)
- how (who?) the system was designed
- who the 3rd party vendor is (sorry - has a SAP performance problem 

today...)
- whether the sun shines.

In other words: don't bother. I'd worry if users start complaining, and run then statspack - or HotSos's tools.

BTW - the above list is in no way complete.

-- 
Merry Christmas and a Happy New Year,
Frank van Bortel

Received on Tue Dec 23 2003 - 16:13:00 CST