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.
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.
C is incorrect. v$db_buffer_cache_advice gives information about the buffer size not hit ratio
upvoted 1 times
...
This section is not available anymore. Please use the main Exam Page.1z0-084 Exam Questions
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
1 month, 2 weeks ago