64. Which two statements are true about setting the FAST_START_MTTR_TARGET initialization
parameter to a nonzero value? (Choose two.)
A.The MTTR advisor will be disabled.
B.Automatic checkpoint tuning will be enabled.
C.The value for the LOG_CHECKPOINT_INTERVAL initialization parameter will be override the value for
FAST_START_MTTR_TARGET.
D.The time taken to recover the instance after the crash is always exactly the same as the value given for
the FAST_START_MTTR_TARGET initialization parameter.
Answer: BC
B 是对的
C 与文档所述不一致
http://docs.oracle.com/cd/E11882_01/server.112/e40402/initparams090.htm#REFRN10058
个人倾向于D
parameter to a nonzero value? (Choose two.)
A.The MTTR advisor will be disabled.
B.Automatic checkpoint tuning will be enabled.
C.The value for the LOG_CHECKPOINT_INTERVAL initialization parameter will be override the value for
FAST_START_MTTR_TARGET.
D.The time taken to recover the instance after the crash is always exactly the same as the value given for
the FAST_START_MTTR_TARGET initialization parameter.
Answer: BC
B 是对的
10.5.3.3.1 Enabling MTTR Advisor
To enable MTTR Advisor, set the two initialization parameters STATISTICS_LEVEL
and FAST_START_MTTR_TARGET
.
STATISTICS_LEVEL
governs whether all advisors are enabled and is not specific to MTTR Advisor. Ensure that it is set to TYPICAL
or ALL
. Then, whenFAST_START_MTTR_TARGET
is set to a nonzero value, the MTTR Advisor is enabled.
C 与文档所述不一致
http://docs.oracle.com/cd/E11882_01/server.112/e40402/initparams090.htm#REFRN10058
FAST_START_MTTR_TARGET
enables you to specify the number of seconds the database takes to perform crash recovery of a single instance. When specified,
FAST_START_MTTR_TARGET
is overridden by
LOG_CHECKPOINT_INTERVAL
.个人倾向于D