Oracle Database 12c: Advanced Administration — Question 4

Which two statements are true about setting the FAST_START_MTTR_TARGET parameter to a nonzero value?

Answer options

• A. The MTTR advisor is enabled only if the value is greater than the default value.
• B. Automatic checkpoint tuning is enabled.
• C. The value of the LOG_CHECKPOINT_INTERVAL parameter overrides the value of the FAST_START_MTTR_TARGET parameter.
• D. The time taken to recover an instance after a crash is always exactly the same as the value set for the FAST_START_MTTR_TARGET parameter.

Correct answer: A, C

Explanation

Statement A is correct because the MTTR advisor only functions when the FAST_START_MTTR_TARGET is greater than the default setting. Statement C is also true as the LOG_CHECKPOINT_INTERVAL does take precedence over the FAST_START_MTTR_TARGET. The other statements B and D are incorrect; automatic checkpoint tuning isn't solely dependent on this parameter and recovery time does not strictly equal the FAST_START_MTTR_TARGET value.