wrong data in v$buffer_pool_statistics?

From: Luis Santos <lcdsantos_at_gmail.com>
Date: 5 May 2006 07:27:34 -0700
Message-ID: <1146839254.245911.252550@j73g2000cwa.googlegroups.com>

Hi, I have a 9.2.0.3 database. Look at this. Is the data in v$buffer_pool_statistics wrong? Or am I wrong?

I have just one buffer pool.

SQL> select ID, NAME, BLOCK_SIZE, CURRENT_SIZE from v$buffer_pool;

        ID NAME                 BLOCK_SIZE CURRENT_SIZE


---------- -------------------- ---------- ------------

         3 DEFAULT                    8192          208

SQL> SELECT (1 - (vbps.physical_reads / (vbps.db_block_gets + vbps.consistent_gets)))
  2 * 100 "Hit Ratio"
  3 FROM v$buffer_pool_statistics vbps
  4 /

Hit Ratio

---

  -114,88

SQL> SELECT (1 - (physical_reads.value/ (db_block_gets.value + consistent_gets.value)))
  2 * 100 "Hit Ratio"
  3 FROM v$sysstat db_block_gets, v$sysstat consistent_gets, v$sysstat physical_reads
  4 WHERE db_block_gets.name = 'db block gets'   5 AND consistent_gets.name = 'consistent gets'   6 AND physical_reads.name = 'physical reads'   7 /

Hit Ratio

---

    93,55

SQL> @ver

VERSION

---

9.2.0.3.0 Received on Fri May 05 2006 - 09:27:34 CDT