Re: Cache Hit Ratio from system views

Bob Jones wrote:
> No, you either have not read all the threads or make no effort to understand
> my point.

I have read and read your posts Bob. You've stated that the BCHR ratio tells you the disk IO percentage which is sort of true - though it rather begs the question of what you understand by disk since strictly it tells you the ratio of IO that Oracle obtains from it's own cache to that which it has to make filesystem IO calls for, and on lots of installations a filesystem call won't come from disk at all. .
> I will wait unitl you get into an objective mindset, or am I being too
> optimistic.

If the BCHR is an objective indicator, please tell us of what you think it is an indicator, and how - specifically you would use it. Richard's indicator (as mine) is how long business transaction take. Definitely objective and relatively straightforward to use and understand.

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info/services