nerdexam
Oracle

1Z0-052 · Question #54

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.)

The correct answer is B. The MTTR advisor will be disabled C. Automatic checkpoint tuning will be disabled. Setting FAST_START_MTTR_TARGET=0 disables both the MTTR advisor and automatic checkpoint tuning, because Oracle has no recovery-time target to optimize against.

Managing the Database Instance

Question

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.)

Options

  • AThe SGA advisor will be disabled
  • BThe MTTR advisor will be disabled
  • CAutomatic checkpoint tuning will be disabled
  • DCheckpoint information will not be written to the alert log file

How the community answered

(26 responses)
  • A
    8% (2)
  • B
    77% (20)
  • D
    15% (4)

Why each option

Setting FAST_START_MTTR_TARGET=0 disables both the MTTR advisor and automatic checkpoint tuning, because Oracle has no recovery-time target to optimize against.

AThe SGA advisor will be disabled

The SGA advisor is controlled by the DB_CACHE_ADVICE parameter and the STATISTICS_LEVEL setting, and operates independently of checkpoint or MTTR parameters.

BThe MTTR advisor will be disabledCorrect

FAST_START_MTTR_TARGET=0 explicitly disables the MTTR advisor, which requires a non-zero target to calculate optimal checkpoint frequency and report estimated recovery times in the V$INSTANCE_RECOVERY view.

CAutomatic checkpoint tuning will be disabledCorrect

Automatic checkpoint tuning - where Oracle dynamically adjusts checkpoint frequency to meet the MTTR target - is also disabled when FAST_START_MTTR_TARGET=0 and LOG_CHECKPOINT_INTERVAL=0, leaving checkpoint behavior untuned.

DCheckpoint information will not be written to the alert log file

Checkpoint information (checkpoint SCN, completion times) is always written to the alert log regardless of FAST_START_MTTR_TARGET or LOG_CHECKPOINT_INTERVAL values.

Concept tested: FAST_START_MTTR_TARGET and automatic checkpoint tuning

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/FAST_START_MTTR_TARGET.html

Topics

#FAST_START_MTTR_TARGET#automatic checkpoint tuning#MTTR advisor#checkpoint

Community Discussion

No community discussion yet for this question.

Full 1Z0-052 Practice