Which two statements are true about setting the FAST_START_MTTR_TARGET parameter to a nonzero value?
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 the expected 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 specified, then MTTR advisory will be OFF.
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
BC
for A, it should be non zero value?