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.
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)- A20% (7)
- B71% (25)
- D9% (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.
Disabling automatic checkpoint tuning removes Oracle's ability to self-optimize checkpoint intervals, which would likely worsen rather than resolve checkpoint-related performance problems.
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.
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.
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
Community Discussion
No community discussion yet for this question.