nerdexam
Oracle

1Z0-052 · Question #221

Your database performance has degraded due to frequent checkpointing. What would you do in this scenario?

The correct answer is C. make the changes as per the advice given by MTTR Advisor. Frequent checkpointing degrades database performance; Oracle's MTTR Advisor provides recommendations to optimize redo log sizes and checkpoint intervals.

Managing the Database Instance

Question

Your database performance has degraded due to frequent checkpointing. What would you do in this scenario?

Options

  • Amake redo log files smaller
  • Bincrease the size of the checkpoint file
  • Cmake the changes as per the advice given by MTTR Advisor
  • Dmake the changes as per the advice given by Checkpoint Advisor

How the community answered

(23 responses)
  • A
    4% (1)
  • B
    4% (1)
  • C
    83% (19)
  • D
    9% (2)

Why each option

Frequent checkpointing degrades database performance; Oracle's MTTR Advisor provides recommendations to optimize redo log sizes and checkpoint intervals.

Amake redo log files smaller

Making redo log files smaller causes them to fill up more quickly, which forces Oracle to checkpoint more frequently, directly worsening the performance degradation.

Bincrease the size of the checkpoint file

There is no 'checkpoint file' with a configurable size in Oracle Database; this option describes a non-existent parameter.

Cmake the changes as per the advice given by MTTR AdvisorCorrect

The MTTR (Mean Time To Recover) Advisor in Oracle Database analyzes workload and I/O characteristics to recommend optimal redo log file sizes and FAST_START_MTTR_TARGET settings. These recommendations directly reduce unnecessary checkpoint frequency while keeping recovery time within acceptable bounds. Following MTTR Advisor advice is the supported Oracle method for resolving checkpoint-related performance issues.

Dmake the changes as per the advice given by Checkpoint Advisor

There is no Oracle advisor called 'Checkpoint Advisor'; the correct advisor that addresses checkpoint frequency and recovery time is the MTTR Advisor.

Concept tested: Oracle MTTR Advisor and checkpoint optimization

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/tgdba/instance-tuning-using-performance-views.html

Topics

#MTTR Advisor#checkpointing#database performance#redo log sizing

Community Discussion

No community discussion yet for this question.

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