Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle slowed down
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? >> >>
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