Which two statements are true about setting the FAST_ST…

Which two statements are true about setting the FAST_START_MTTR_TARGET parameter to a nonzero value?

Which two statements are true about setting the FAST_START_MTTR_TARGET parameter to a nonzero value?

A.
The MTTR advisor is enabled only if the value is greater than the default value.

B.
Automatic checkpoint tuning is enabled.

C.
The value of the LOG_CHECKPOINT_INTERVAL parameter overrides the value of the FAST_START_MTTR_TARGET parameter.

D.
The time taken to recover an instance after a crash is always exactly the same as the value set for the FAST_START_MTTR_TARGET parameter.

Show Hint

Leave a Reply 5

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

Flame

Flame

CD

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

Reply

le_admin

le_admin

B and C

D is not correct. You cannot expect recovery time to be EXACTLY same as FAST_START_MTTR_TARGET value. Oracle is only TRYING to respect this.

Reply

amsunhasav

amsunhasav

BC
https://docs.oracle.com/en/database/oracle/oracle-database/12.2/refrn/FAST_START_MTTR_TARGET.html#GUID-D2452F33-0FD8-4297-85EC-FF63A0F03499
“When specified, FAST_START_MTTR_TARGET is overridden by LOG_CHECKPOINT_INTERVAL.”

“Oracle support Docs”

Oracle Database 10g supports automatic checkpoint tuning which takes advantage of periods of low I/O usage to advance checkpoints and therefore improve availability. Automatic checkpoint tuning is in effect if the FAST_START_MTTR_TARGET database initialization parameter is set to a nonzero value. Observe the following recommendations to take advantage of automatic checkpoint tuning.

Reply