nerdexam
Oracle

1Z0-052 · Question #47

Which two statements are true about setting the FAST_START_MTTR_TARGET initialization parameter to a nonzero value? (Choose two.)

The correct answer is B. Automatic checkpoint tuning will be enabled C. The value for the LOG_CHECKPOINT_INTERVAL initialization parameter will be override the value. Setting FAST_START_MTTR_TARGET to a nonzero value enables automatic checkpoint tuning and causes Oracle to override the LOG_CHECKPOINT_INTERVAL parameter.

Managing the Database Instance

Question

Which two statements are true about setting the FAST_START_MTTR_TARGET initialization parameter to a nonzero value? (Choose two.)

Options

  • AThe MTTR advisor will be disabled
  • BAutomatic checkpoint tuning will be enabled
  • CThe value for the LOG_CHECKPOINT_INTERVAL initialization parameter will be override the value
  • DThe time taken to recover the instance after the crash is always exactly the same as the value given

How the community answered

(25 responses)
  • A
    12% (3)
  • B
    80% (20)
  • D
    8% (2)

Why each option

Setting FAST_START_MTTR_TARGET to a nonzero value enables automatic checkpoint tuning and causes Oracle to override the LOG_CHECKPOINT_INTERVAL parameter.

AThe MTTR advisor will be disabled

Setting FAST_START_MTTR_TARGET to a nonzero value enables the MTTR advisor; it is setting the parameter to 0 that disables both automatic checkpoint tuning and the MTTR advisor.

BAutomatic checkpoint tuning will be enabledCorrect

A nonzero FAST_START_MTTR_TARGET activates automatic checkpoint tuning, where Oracle dynamically adjusts checkpoint frequency to meet the specified recovery time target without requiring manual configuration of checkpoint-related parameters.

CThe value for the LOG_CHECKPOINT_INTERVAL initialization parameter will be override the valueCorrect

When FAST_START_MTTR_TARGET is set to a nonzero value, Oracle ignores and effectively overrides any value configured for LOG_CHECKPOINT_INTERVAL, because the MTTR-based algorithm takes full control of checkpoint frequency.

DThe time taken to recover the instance after the crash is always exactly the same as the value given

The recovery time is not guaranteed to be exactly the specified value - FAST_START_MTTR_TARGET is a best-effort target, and actual instance recovery time can vary based on workload and I/O conditions.

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#LOG_CHECKPOINT_INTERVAL

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 1Z0-052 Practice