db buffer cache

From: Daud <daud11_at_hotmail.com>
Date: 6 Aug 2002 02:22:03 -0700
Message-ID: <f0bf3cc3.0208060122.6d1f40c2@posting.google.com>

I was trying to calculate the db buffer cache hit ratio by querying v$sysstat.
I got the values for db block gets, consistent gets and physical reads and compared them against v$buffer_pool_statistics. The difference is huge for consistent gets. Why is that? Shouldn't the total for each of the 3 be the same as the values that I would get from v$sysstat? In my case, I have only one pool - the DEFAULT and the values are different too.

Am I missing something here?

rgds
Daud Received on Tue Aug 06 2002 - 04:22:03 CDT