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. Increase the number of members for all log groups.

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

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

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

When checkpoints frequently fail to complete, it typically indicates DBWn processes cannot write dirty blocks fast enough before the next checkpoint is due. Increasing the number of database writer (DBWn) processes allows more parallel writes, helping checkpoints complete on time. Options A and B are incorrect because ARCn and redo log members affect archiving, not checkpoint writing. Option C is incorrect because LGWR is a single process and cannot be multiplied; it writes to redo logs, not datafiles.