Re: Oracle slowed down

From: Brian Peasland <oracle_dba_at_nospam.peasland.net>
Date: Sat, 22 Apr 2006 15:21:46 GMT
Message-ID: <Iy4qoF.C05@igsrsparc2.er.usgs.gov>

Frank van Bortel wrote:
> Brian Peasland wrote:
>

>> I cannot say that I've seen a BCHR of 30% perform better than 100%, all
>> else being equal. But what I have seen is a BCHR of 100% perform just as
>> poorly as a BCHR of 30% due to very bad SQL.
>>
>> Cheers,
>> Brian
>>

>
> Ahm... wouldn't that be the equivalent, but for a fraction?
> Better is >, just as poorly is <=?
>

Splitting hairs.....

If you use the function P_BCHR(x) to denote the application Performance when the Buffer Cache Hit Ratio is x%, then what I said is:

P_BCHR(30%) <= P_BCHR(100%)
P_BCHR(30%) = P_BCHR(100%)

So the two statements aren't really equivalent, in a logical sense. "But for a fraction", they are equivalent on the end case. :)

Just having fun on a Saturday!!!! ;)

Cheers,
Brian

-- 
===================================================================

Brian Peasland
oracle_dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

Received on Sat Apr 22 2006 - 10:21:46 CDT