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 specifies the mean time to recover (MTTR) in seconds, which directly influences checkpoint frequency. Oracle automatically adjusts checkpoint intervals to meet the specified recovery time goal, affecting the roll forward phase during crash recovery.