Hi I need to increase the db_block buffers from 2000 to a higher number. Is there a formula I can use to apply to calculate? My hit ratio is @ 80 rather then 95%
thanks
Jigar
Printable View
Hi I need to increase the db_block buffers from 2000 to a higher number. Is there a formula I can use to apply to calculate? My hit ratio is @ 80 rather then 95%
thanks
Jigar
Not really. Increase to 2500 and see if you need to increase it more.
Generally the 25% of Physical RAM gives a good hit, but in 8.1.6 onwards there is no way to find without changing the parameter.