Under Database Browser | Overview Grids, the Buffer Cache has a negative value.
Toad uses the following query when getting the value:
Select inst_id, 'Buffer Cache' name, round(100 * (1-(physical_reads/(db_block_gets+consistent_gets))), 2) valueFROM gv$buffer_pool_statisticsWHERE name = 'DEFAULT'
WORKAROUND 1
Run the following from the editor to get a more realistic value:
SELECT ROUND((1-(phy.value / (cur.value + con.value)))*100,2) "Cache Hit Ratio" ROM v$sysstat cur, v$sysstat con, v$sysstat phyWHERE cur.name = 'db block gets'AND con.name = 'consistent gets'AND phy.name = 'physical reads';
STATUS
Waiting for fix in a future release of Toad for Oracle.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center