select trunc((1-(sum(decode(name,'physical reads',value,0)) /
(sum(decode(name,'consistent gets',value,0)) +
(sum(decode(name,'db block gets',value,0)))))) * 100) "Buffer Hit Ratio"
from v$sysstat
where statistic# in (38,39,40)
；