Oracle
1Z0-034 · Question #70
You notice that the performance of the database has degraded because of frequent checkpoints. Which two actions resolve the issue?
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. See the full explanation below for the reasoning.
Question
You notice that the performance of the database has degraded because of frequent checkpoints. Which two actions resolve the issue?
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
How the community answered
(35 responses)- A20% (7)
- B71% (25)
- D9% (3)
Community Discussion
No community discussion yet for this question.