Which two statements are true about the interpretation …

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.)

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.)

A.
A high value indicates that the buffer cache is adequately sized for the current workload.

B.
Poor hit ratios indicate that a large number of indexed lookups or small table scans are being performed.

C.
A low hit ratio does not necessarily imply that increasing the size of the buffer cache will improve
performance.

D.
A high hit ratio may indicate that repeated scanning of the same large table or index is being performed.

E.
A low hit ratio indicates that a KEEP buffer pool should be configured based on the size of the largest object
accessed in the buffer cache.



Leave a Reply 0

Your email address will not be published. Required fields are marked *