Re: Buffer Cache Hit Ration Formulas??

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 12 Aug 1999 15:23:24 +0100
Message-ID: <934468837.4001.1.nnrp-04.9e984b29@news.demon.co.uk>

Known bug in v$buffer_pool_statistics.
Can't remember the reference or details though, sorry.

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

>
>The different story is why this three statistics do not match in
>V$SYSSTAT as opposed to V$BUFFER_POOL_STATISTICS. Here is a query I
>run a couple of times soon after the database was restarted. Note that
>I have only DEFAULT buffer pool (no KEEP and NO recycle POOL).
>
Received on Thu Aug 12 1999 - 09:23:24 CDT