Database Monitoring   «Prev 
 

Buffer cache hit Ratio - Quiz


1. What does the buffer cache hit ratio tell you?
Please select the best answer.
  A. The relative number of times that the buffer cache hit the size limit that you specified
  B. The relative number of times that a user executed a query that accessed the buffer cache
  C. The relative number of times that a needed database block was found to be in memory
  D. The relative number of times that an SQL query was able to fit entirely within the cache

2. Which of the following formulas correctly computes the buffer cache hit ratio?
Please select the best answer.
  A. physical reads / (db block gets + consistent gets))
  B. 1 - (physical reads / (db block gets + consistent gets))
  C. (db block gets + consistent gets)) / physical reads
  D. (db block gets + consistent gets)) / physical reads - 1

3. If your buffer cache hit ratio is low, what should you do in an attempt to improve it?
Please select the best answer.
  A. Increase the value of the db_block_size parameter.
  B. Increase the value of the log_buffers parameter.
  C. Increase the value of the shared_pool_size parameter.
  D. Increase the value of the db_block_buffers parameter.

-
4. What can you do to increase either the dictionary cache hit ratio or the library cache hit ratio?
Please select the best answer.
  A. Increase the value of the db_block_size parameter.
  B. Increase the value of the log_buffers parameter.
  C. Increase the value of the shared_pool_size parameter.
  D. Increase the value of the db_block_buffers parameter.
Score =
Correct answers: