Re: Oracle slowed down

From: Bob Jones <email_at_me.not>
Date: Sat, 22 Apr 2006 15:46:15 GMT
Message-ID: <bds2g.50956$_S7.27240@newssvr14.news.prodigy.com>

"ianal Vista" <ianal_vista_at_hotmail.com> wrote in message news:Xns97AD50524AA8Aianalvistahotmailcom_at_70.169.32.36...
> "Bob Jones" <email_at_me.not> wrote in news:ggr2g.62833$F_3.20420
> @newssvr29.news.prodigy.net:
>
>>
>> "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?
>>
>>
>>
>
> Yes, it can be good/acceptable.
>

Really? You must have a very unique system, either with an unusually small set of data or unusually little activities.

> Quantify "good".

You will have to quantify it yourself. What is good for you? Received on Sat Apr 22 2006 - 10:46:15 CDT