Re: Oracle slowed down

From: Bob Jones <email_at_me.not>
Date: Sat, 22 Apr 2006 16:38:46 GMT
Message-ID: <q_s2g.50964$_S7.11667@newssvr14.news.prodigy.com>

"HansF" <News.Hans_at_telus.net> wrote in message news:pan.2006.04.22.15.07.44.552134_at_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.
>

Including the ones coming from disks? Received on Sat Apr 22 2006 - 11:38:46 CDT