Re: Buffer cache Hit - Perf overview

From: Jared Still <jkstill_at_bcbso.com>
Date: Fri, 27 Oct 2000 07:00:06 -0700 (PDT)
Message-Id: <10662.120438@fatcity.com>

On Thu, 26 Oct 2000, John Kanagaraj wrote:

> /SOAPBOX ON, FLAMEPROOF SUIT ON
>
> This is one myth that is being broken (and not too soon!). You (and many
> of us) need to unlearn the notion that a 99% hit ratio is not
> necessarily GOOD. As you yourself stated, the response is good, so
> what's the problem??
>
> /SOAPBOX OFF, FLAMEPROOF SUIT OFF
>

When I'm checking the per user buffer hit ratios, and I see a consistent 99%, I suspect one of two things:

Cartestian join - they make the hit ratio look good, but make the user or developer look stupid.
Reading the same rows from the same table millions of times in quick succession. Whatsa matter with these guys? Never heard of using variables?

Jared Still
Certified Oracle DBA and Part Time Perl Evangelist ;-) Regence BlueCross BlueShield of Oregon
jkstill_at_bcbso.com - Work - preferred address jkstill_at_teleport.com - private Received on Fri Oct 27 2000 - 09:00:06 CDT