1Z0-052 · Question #54
Examine the values for the following initialization parameters: FAST_START_MTTR_TARGET=0 LOG_CHECKPOINT_INTERVAL=0 Which two will be the implications of these values in your database? (Choose two.)
The correct answer is B. The MTTR advisor will be disabled C. Automatic checkpoint tuning will be disabled. Setting FAST_START_MTTR_TARGET=0 disables both the MTTR advisor and automatic checkpoint tuning, because Oracle has no recovery-time target to optimize against.
Question
Examine the values for the following initialization parameters:
FAST_START_MTTR_TARGET=0 LOG_CHECKPOINT_INTERVAL=0 Which two will be the implications of these values in your database? (Choose two.)
Options
- AThe SGA advisor will be disabled
- BThe MTTR advisor will be disabled
- CAutomatic checkpoint tuning will be disabled
- DCheckpoint information will not be written to the alert log file
How the community answered
(26 responses)- A8% (2)
- B77% (20)
- D15% (4)
Why each option
Setting FAST_START_MTTR_TARGET=0 disables both the MTTR advisor and automatic checkpoint tuning, because Oracle has no recovery-time target to optimize against.
The SGA advisor is controlled by the DB_CACHE_ADVICE parameter and the STATISTICS_LEVEL setting, and operates independently of checkpoint or MTTR parameters.
FAST_START_MTTR_TARGET=0 explicitly disables the MTTR advisor, which requires a non-zero target to calculate optimal checkpoint frequency and report estimated recovery times in the V$INSTANCE_RECOVERY view.
Automatic checkpoint tuning - where Oracle dynamically adjusts checkpoint frequency to meet the MTTR target - is also disabled when FAST_START_MTTR_TARGET=0 and LOG_CHECKPOINT_INTERVAL=0, leaving checkpoint behavior untuned.
Checkpoint information (checkpoint SCN, completion times) is always written to the alert log regardless of FAST_START_MTTR_TARGET or LOG_CHECKPOINT_INTERVAL values.
Concept tested: FAST_START_MTTR_TARGET and automatic checkpoint tuning
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/FAST_START_MTTR_TARGET.html
Topics
Community Discussion
No community discussion yet for this question.