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
答案解析:
参考:http://blog.csdn.net/rlhua/article/details/12616383
A。 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.
故A错误。
而快速启动检查点功能是通过指定所需的非零恢复平均时间(MTTR)值来启用的,该值将用于设置FAST_START_MTTR_TARGET初始化参数。此参数控制数据库对单个实例执行崩溃恢复所花费的时间量。启用快速启动检查点功能时,oracle将自动保持检查点的速度,已便达到请求的MTTR.如果将该值设置为0,将禁用此功能。
故B正确。
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
.
FAST_START_MTTR_TARGET
会被 LOG_CHECKPOINT_INTERVAL所覆盖,故C正确。
官方参考:http://docs.oracle.com/cd/E11882_01/server.112/e40402/initparams090.htm#sthref268
再分享一下我老师大神的人工智能教程吧。零基础!通俗易懂!风趣幽默!还带黄段子!希望你也加入到我们人工智能的队伍中来!https://blog.csdn.net/jiangjunshow