Oracle buffer catch hit ratio is low.
We are facing problem with oracle buffer catch hit ratio problem in our quality system.
Often it falling down to below 50% and reaching to more then 90% with in few minutes.
"db_cache_size parameter value is 5008M". Is it suficent value or we need to increase it?
What may be the reasion for the temperary issue with buffer catch hit ratio?
Our "databse size aproximately 4 TB" and oracle is 11g R2 running on HP Unix.SAP is ECC6.
suggestions and solutions would be appriciated.
Thanks & Regards,