-
Low Buffer hit ratio
Statspack report is showing very low buffer hit ratio of 59.23%. I have noticed some full table scans. Some direction to fix the buffer hit ratio is kindly appreciated.
Following are the details from statspack report.
Cache Sizes (end)
~~~~~~~~~~~~~~~~~
Buffer Cache: 1,433M Std Block Size: 8K
Shared Pool Size: 512M Log Buffer: 1,024K
Instance Efficiency Percentages (Target 100%)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Buffer Nowait %: 97.82 Redo NoWait %: 97.29
Buffer Hit %: 59.23 In-memory Sort %: 100.00
Library Hit %: 96.34 Soft Parse %: 82.45
Execute to Parse %: 47.20 Latch Hit %: 100.00
Parse CPU to Parse Elapsd %: 34.76 % Non-Parse CPU: 84.66
-
why do you feel it is incorrect - it means nothing.
Are you experiencing specific problems which you have atttibuted to a buffer cache problem.
full table scans arent bad either, a low buffer cache hit ration is not bad.
So what specific problems do you have?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|