Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle slowed down

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US