Performance Tuning - Question 041

Checkpoints occur too frequently, causing performance problems. Which of these are valid solutions? (Choose two.)

A . Decrease LOG_CHECKPOINT_TIMEOUT.

B. Increase LOG_CHECKPOINT_TIMEOUT.

C. Increase the size of the redo logs.

D . Decrease the size of the redo logs.

Explanation:

Answer B and C: Increasing the size of the redo logs will reduce the frequency of checkpoints caused by a log switch, called complete checkpoints. Increasing the LOG_CHECKPOINT_TIMEOUT will also reduce the number of incremental checkpoints.