🎴 Flashcard Mode
DB2 and Oracle Database Administration
Card1 / 20
Mastered0
Review0
QuestionClick to flip
Which three initialization parameters are no longer needed when FAST_START_MTTR_TARGET is defined? (Choose three)
AnswerClick to flip back
A
FAST_START_IO_TARGET
B
LOG_CHECKPOINT_TIMEOUT
C
LOG_CHECKPOINT_INTERVAL
💡 Explanation:
FAST_START_MTTR_TARGET is a simplified parameter that automatically manages several recovery-related initialization parameters. When set, Oracle automatically controls FAST_START_IO_TARGET (I/O targets for recovery), LOG_CHECKPOINT_TIMEOUT (time-based checkpoint frequency), and LOG_CHECKPOINT_INTERVAL (redo-based checkpoint frequency). These manual parameters become redundant and should not be set.