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
arebeing 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 aKEEPbuffer pool should be configured based on the size of
the largest object accessed in the buffer cache.



Leave a Reply 8

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


Oracool

Oracool

imo, C and D are correct.
A is wrong because high ratio value NOT necessarily an indication of buffer cache adequately sized. DBA can run the same query over and over and buffer cache hit ratio would increase.

D is correct because “Repeated scanning of the same large table or index can artificially inflate a low cache hit ratio” . That is exactly what D states.

Fonx

Fonx

C,D

A means no necessarily
B is a joke
E is a trap.. not complete => creating a keep in a 2mb buffer cache would not help