Multiple choice

The alert log file for a database instance indicated that the checkpoints are frequently failing to complete. Which of the following actions would be a remedy in this situation?

  1. Increase the number of archiver (ARCn) processes

  2. Increasing the number of members for all log groups

  3. Increasing the number of log writer (LGWR) processes

  4. Increasing the number of database writer (DBWn) processes

Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Increasing the number of database writer (DBWn) processes