Re: Oracle slowed down

From: HansF <News.Hans_at_telus.net>
Date: Sat, 22 Apr 2006 16:02:51 GMT
Message-Id: <pan.2006.04.22.15.07.44.552134@telus.net>

On Sat, 22 Apr 2006 14:41:16 +0000, Bob Jones wrote:

>
> "Frank van Bortel" <frank.van.bortel_at_gmail.com> wrote in message
> news:e2dbje$i9k$2_at_news3.zwoll1.ov.home.nl...

>> Bob Jones wrote:
>>>
>>> I completely agree with you. There is no fixed ratio to shoot for, but
>>> 20%
>>> is unacceptable for DW or OLTP.
>>>
>>>
>> Really - why? What does 20% mean?
>>
>>

> It means you have only 20% reads comming from memory. Do you think the
> performance will be good for this number?

Actually, it means that 20% of the reads use the same blocks as other reads previously have used.

Performance at 20% could be no different than perforamnce at 99%.

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** Top posting [replies] guarantees I won't respond. ***

Received on Sat Apr 22 2006 - 11:02:51 CDT