Which two statements are true about the use and monitoring of Buffer Cache Hit ratios and their value in tuning Database I/O performance? (Choose two.)
A.
The performance of workloads that primarily generate full table scans and fast full index scans are always affected by the cache hit ratio.
B.
A 99% cache hit ratio can be observed for database instances which have very poor I/O performance.
Most Voted
C.
The buffer cache advisory view v$db_cache_advice provides advice on cache hit ratios appropriate for the instance workload.
D.
Both the RECYCLE and KEEP buffer caches should always have a very high cache hit ratio.
E.
A 60% cache hit ratio can be observed for database instances which have very good I/O performance.
Most Voted
C is incorrect. v$db_buffer_cache_advice gives information about the buffer size not hit ratio
upvoted 1 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
krwi1
2 weeks, 4 days ago