Total buffer cache hit percentage too low
Hi all,
Sorry to ask the above question but I am not comfortable with finding the performance bottleneck & resolving the tuning issues.
We are having very low buffer cache hit percentage which is "Total buffer cache hit percentage (52.09%) too low " . I want to know that if there is really a problem then how could i approach to it? and what are the factors that effect the buffer cache getting a lower percentage? How to troubleshooot it? Please I need a step by step guide/approach to resolve this issue.
DB version : 10.2.0.4
Cluster : yes ( 2-node cluster)
OS version : Red Hat Enterprise Linux Server release 5.7 (Tikanga)
Let me know any information is required or not.
Regards,
Imran khan