Re: Does anybody really use Oracle 8i on Win2k?

"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:anjrr8$fsi$1$8300dec7_at_news.demon.co.uk...
> The buffer cache hit ratio means:
>
> This is proportion of block accesses that
> appeared to have been satisfied in memory
> based on the counts that Oracle gave you,
> but those numbers could have very little
> relationship to what actually happened and
> could easily be out by a factor of two.

I wasn't aware of this. Is there a simple demonstration for this?

> you've also forgotten to factor in some of the
> Stats that Oracle did give you but usually
> don't get referenced in the standard formula.

I omitted this discussion on the basis that even if you do get the 'right' measure for hit ratio it's still not a good thing to be measuring. (Except for those of us with perfectly tuned apps).

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************