Oracle 11G OCP 1Z0-052 63

（63）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.)

A. The SGA advisor will be disabled.

B. The MTTR advisor will be enabled.

C. Automatic checkpoint tuning will be disabled.

D. Checkpoint information will not be written to the alert log file.

答案：（B、C）

解析：

FAST_START_MTTR_TARGET,允許你指定資料庫進行crash revoery的時間.

如果指定了LOG_CHECKPOINT_INTERVAL引數，FAST_START_MTTR_TARGET引數將被覆蓋.

《Performance Tuning》 10.5.3.3.1

為了開啟MTTR Advisor，需要設定STATISTICS_LEVEL和FAST_START_MTTR_TARGET兩個引數.

STATISTICE_LEVEL控制所有的ADVISOR是否開啟，並不只是針對MTTR Advisor。要設定為TYPICAL | ALL

如果FAST_START_MTTR_TARGET = 0,則MTTR Advisor開啟

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/17013648/viewspace-1180953/，如需轉載，請註明出處，否則將追究法律責任。