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

Just to split hairs a bit:

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. And     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.

--
Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

Next Seminar dates:
(see http://www.jlcomp.demon.co.uk/seminar.html )

____USA__________November 7/9   (Detroit)
____USA__________November 19/21 (Dallas)
____England______November 12/14

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html



Niall Litchfield wrote in message
<3d9d6c47$0$8508$ed9e5944_at_reading.news.pipex.net>...


>

>

such and such a


>proportion of the execution plan that was chosen was answered from memory

>not disk.

>