SQL> column hit_ratio format 990.99
SQL> select (1-(sum(decode(name,'physical reads',value,0)) /
(sum(decode(name,'db block gets',value,0)) +
sum(decode(name,'consistent gets',value,0))))) as hit_ratio
from v$sysstat;
HIT_RATIO
---------
0.88
Monday, February 25, 2008
Buffer Cache Hit Ratio
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment