Low Hit ratio
Just now i run this query,
SQL> select round ((1-(sum(decode(name,'physical reads',value,0))/(sum(decode(na
me, 'db block gets',value,0)) + sum(decode(name, 'consistent gets',value,0)))))
* 100,4)hitratio from v$sysstat;
me, 'db block gets',value,0)) + sum(decode(name, 'consistent gets',value,0)))))
* 100,4)hitratio from v$sysstat;
HITRATIO
----------
37.0811
----------
37.0811
Now my database hit ratio is 37.08 Oracle recommands <90 hit ratio.
Please help me to increase the hit ratio.
Please help me to increase the hit ratio.
Thanks in advance.
0