Which two statements are true about setting the FAST_ START_ MTTR_ TARGET initialization parameter to a nonzero value?

Which two statements are true about setting the FAST_ START_ MTTR_ TARGET initialization
parameter to a nonzero value?

Which two statements are true about setting the FAST_ START_ MTTR_ TARGET initialization
parameter to a nonzero value?

A.
The MTTR advisor will be disabled.

B.
Automatic checkpoint tuning will be enabled.

C.
The value for the LOG_CHECKPIONT_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.

Show Hint

Leave a Reply 2

Your email address will not be published. Required fields are marked *

Kiran

Kiran

Ans : B and C

Note:
Whenever you set FAST_START_MTTR_TARGET to a nonzero value, and while MTTR advisory is ON, Oracle Corporation recommends that you disable (set to 0) the following parameters:

LOG_CHECKPOINT_TIMEOUT
LOG_CHECKPOINT_INTERVAL
FAST_START_IO_TARGET
Because these initialization parameters either override FAST_START_MTTR_TARGET or potentially drive checkpoints more aggressively than FAST_START_MTTR_TARGET does, they can interfere with the simulation.

Reply