Which two statements are true about setting the FAST_START_MTTR_TARGET parameter to a nonzero value? specified, then MTTR advisory will be OFF.
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.
Explanation:
The FAST_START_MTTR_TARGET initialization parameter lets you specify in seconds the expected “mean time to recover” (MTTR), which is theexpected amount of time Oracle takes to perform crash or instance recovery for a single instance.
To enable MTTR advisory, set the initialization parameter FAST_START_MTTR_TARGET to a nonzero value. If FAST_START_MTTR_TARGET is not
When specified, FAST_START_MTTR_TARGET is overridden by LOG_CHECKPOINT_INTERVAL.
Note: The default value is 0. Range of values is 0 to 3600 seconds.
References: https://docs.oracle.com/cd/B28359_01/server.111/b28320/initparams079.htm#REFRN10058 https://docs.oracle.com/cd/A97630_01/
server.920/a96533/instreco.htm