Multiple choice

What steps should be taken to gather information about checkpoints?

  1. Set the LOG_CHECKPOINTS_TO_ALERT initialization parameter to TRUE. Monitor the alert log file.

  2. Set the LOG_CHECKPOINT_TIMEOUT parameter. Force a checkpoint by using the FAST_START_MTTR_TARGET parameter. Monitor the alert log file.

  3. Set the LOG_CHECKPOINT_TIMEOUT parameter. Force a log switch by using the command ALTER SYSTEM FORCE LOGSWITCH. Force a checkpoint by using the command ALTER SYSTEM FORCE CHECKPOINT. Monitor the alert log file.

  4. Set the FAST_START_MTTR_TARGET parameter to TRUE. Force a checkpoint by using the command ALTER SYSTEM FORCE CHECKPOINT. Monitor the alert log file.
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Setting LOG_CHECKPOINTS_TO_ALERT to TRUE writes checkpoint information to the alert log, which is the standard method for monitoring checkpoint activity. The other options mix incorrect parameters or unnecessary force operations - you only need to enable logging and monitor the alert log file.

Keep practicing — related questions