Oracle
1Z0-064 · Question #20
Which two statements are true about the interpretation of Buffer Cache Hit Ratio in the Instance Efficiency Percentages section of an AWR report? (Choose two.)
The correct answer is C. A low hit ratio does not necessarily imply that increasing the size of the buffer cache will improve D. A high hit ratio may indicate that repeated scanning of the same large table or index is being. See the full explanation below for the reasoning.
Question
Which two statements are true about the interpretation of Buffer Cache Hit Ratio in the Instance Efficiency Percentages section of an AWR report? (Choose two.)
Options
- AA high value indicates that the buffer cache is adequately sized for the current workload.
- BPoor hit ratios indicate that a large number of indexed lookups or small table scans are being
- CA low hit ratio does not necessarily imply that increasing the size of the buffer cache will improve
- DA high hit ratio may indicate that repeated scanning of the same large table or index is being
- EA low hit ratio indicates that a KEEP buffer pool should be configured based on the size of the
How the community answered
(36 responses)- A14% (5)
- B6% (2)
- C78% (28)
- E3% (1)
Community Discussion
No community discussion yet for this question.