? when determining buffer cache hit ratios
Have run these queries to work out the buffer cache hit ratios only to discover that the selected stats far from match and am a little bewildered, can anyone shed some light.
Apologise for the formatting but originally pasted it to Notepad and it looked spot on...
SVRMGR> select physical_reads, db_block_gets, consistent_gets from v$buffer_pool_STATISTICS;
PHYSICAL_R DB_BLOCK_G CONSISTENT
---------- ---------- ----------
447 3394 14797
1 row selected.
SVRMGR> select * from v$sysstat where name in ('physical reads', 'db block gets', 'consistent gets');
STATISTIC# NAME CLASS VALUE
---------- ---------------------------------------------------------------- ---------- ----------
38 db block gets 8 3394
39 consistent gets 8 32003
40 physical reads 8 1202
3 rows selected.
SVRMGR>
:confused:
Gus
