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 disabled
C.
Automatic checkpoint tuning will be disabled
D.
Checkpoint information will not be written to the alert log file
The MTTR means Mean Time to Recover in Oracle. Lets you configure instance recovery by enabling you to adjust the mean time to recovery setting for an instance.
The MTTR advisory is available to help you evaluate the effect of different MTTR settings on system performance in terms of extra physical writes. The mean time for recovery from a system failure is specified based on business needs by the database administrator using enterprise manager and then needed reconfiguration of Oracle components automatically task place. The FAST_START_MTTR_TARGET enables you to specify the number of seconds the database takes to perform crash recovery of a single instance.