Dear Gurus,
Just now i run the following query:
SQL> select round ((1-(sum(decode(name,'physical reads',value,0)) /
2 (sum(decode(name, 'db block gets',value,0)) +
3 sum(decode(name, 'consistent gets',value,0))))) * 100, 4)
4 hitratio
5 from v$sysstat;
HITRATIO
----------
76.6596
Right now My database hitratio is 76.65. But oracle recommonded hit ratio above 90%.
My Database Buffres(db_cache_size) is 67108864 (Oracle9i Solaris Platform)
How to tune Database Buffers?
Please advise me, Thanks in advance,
Thanks,
Iyyappan.M