Re: buffer hit cache ratio

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Tue, 23 Dec 2003 10:00:41 -0000
Message-ID: <3fe81248$0$9393$ed9e5944@reading.news.pipex.net>

"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?
>
> currently i have about 84% and although the performance is fine i'm
curious
> if i can make it better?

Short answer. Don't get hung up on ratios they don't actually tell you much in and of themselves, focus on the end user experience in terms of elapsed time.

Long answer buy Optimizing Oracle Performance by Cary Millsap and Jeff Holt.

-- 
Niall Litchfield
Oracle DBA
Audit Commission UK

Received on Tue Dec 23 2003 - 04:00:41 CST