nerdexam
Oracle

1Z0-052 · Question #145

You notice that the performance of the database has degraded because of frequent checkpoints. Which two actions resolve the issue? (Choose two.)

The correct answer is B. Check the size of the redo log file size and increase the size if it is small C. Set the FAST_START_MTTR_TARGET parameter as per the advice given by the MTTR Advisor. Frequent Oracle checkpoints are typically caused by small redo log files or an aggressive MTTR target. Increasing redo log size and tuning FAST_START_MTTR_TARGET reduces checkpoint frequency.

Managing the Database Instance

Question

You notice that the performance of the database has degraded because of frequent checkpoints. Which two actions resolve the issue? (Choose two.)

Options

  • ADisable automatic checkpoint tuning
  • BCheck the size of the redo log file size and increase the size if it is small
  • CSet the FAST_START_MTTR_TARGET parameter as per the advice given by the MTTR Advisor
  • DDecrease the number of redo log members if there are more than one redo log members available

How the community answered

(35 responses)
  • A
    20% (7)
  • B
    71% (25)
  • D
    9% (3)

Why each option

Frequent Oracle checkpoints are typically caused by small redo log files or an aggressive MTTR target. Increasing redo log size and tuning FAST_START_MTTR_TARGET reduces checkpoint frequency.

ADisable automatic checkpoint tuning

Disabling automatic checkpoint tuning removes Oracle's ability to self-optimize checkpoint intervals, which would likely worsen rather than resolve checkpoint-related performance problems.

BCheck the size of the redo log file size and increase the size if it is smallCorrect

Small redo log files cause frequent log switches, which trigger checkpoints to free up space for reuse. Increasing redo log file size reduces how often Oracle must checkpoint to recycle logs.

CSet the FAST_START_MTTR_TARGET parameter as per the advice given by the MTTR AdvisorCorrect

The FAST_START_MTTR_TARGET parameter controls how aggressively Oracle checkpoints to meet a target instance recovery time. Setting it based on MTTR Advisor recommendations prevents overly frequent checkpointing while still meeting recovery goals.

DDecrease the number of redo log members if there are more than one redo log members available

The number of redo log members within a group affects redundancy and fault tolerance, not the frequency of checkpoints; reducing members does not address the root cause of excessive checkpointing.

Concept tested: Oracle redo log sizing and checkpoint frequency tuning

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/managing-the-redo-log.html

Topics

#checkpoints#FAST_START_MTTR_TARGET#redo log sizing#MTTR Advisor

Community Discussion

No community discussion yet for this question.

Full 1Z0-052 Practice