Multiple choice

Which initialization parameter affects the roll forward phase of recovery by manipulating the frequency at which checkpoints are written?

  1. FAST_START_IO_TARGET

  2. FAST_START_MTTR_TARGET

  3. LOG_CHECKPOINT_TIMEOUT

  4. LOG_CHECKPOINT_INTERVAL
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

FAST_START_MTTR_TARGET controls the Mean Time To Recover (MTTR) and indirectly affects checkpoint frequency. A lower MTTR target requires more frequent checkpoints, which speeds up the roll forward phase of recovery by reducing redo to apply. Other options either don't control checkpoint frequency (LOG_CHECKPOINT_* parameters control timing directly) or aren't primarily about MTTR.

Keep practicing — related questions