Re: Oracle slowed down

From: Bob Jones <email_at_me.not>
Date: Sat, 22 Apr 2006 01:17:55 GMT
Message-ID: <7vf2g.50878$_S7.47487@newssvr14.news.prodigy.com>

"Joel Garry" <joel-garry_at_home.com> wrote in message news:1145647662.371300.261800_at_z34g2000cwc.googlegroups.com...
> While the hit ratio does obscure most information, it does have one
> possible use, and that is as an indicator that something has changed on
> an otherwise stable system. If you look at the ratio every day and it
> is 86%, and all of a sudden it's declining to 20% after the system has
> been up 8 hours, that would be saying, "hey, something has changed,
> start doing some deeper investigation." The act of trying to hit a
> specific ratio is what is stupid and has been decremented. Or
> excremented, as the case may be. The delta is what is informative.
>

I completely agree with you. There is no fixed ratio to shoot for, but 20% is unacceptable for DW or OLTP. Received on Fri Apr 21 2006 - 20:17:55 CDT