You notice that the performance of the database has degraded because of frequent checkpoints.
Which two actions resolve the issue? (Choose two.)
A.
Disable automatic checkpoint tuning
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
D.
Decrease the number of redo log members if there are more than one redo log members
available in each redo log group
Hey guys are these 226 questions on the OCA?
Can you please send me the complied document, if you have already done that..So that I can save some time for me and also be thankfull to you people.
FAST_START_MTTR_TARGET enables you to specify the number of seconds the database takes to perform crash recovery of a single instance. When specified, FAST_START_MTTR_TARGET is overridden by LOG_CHECKPOINT_INTERVAL.
The MTTR Advisor (Mean Time To Recover Advisor) is enabled when two parameters are set to certain values: STATISTICS_LEVEL and FAST_START_MTTR_TARGET. The required values for STATISTICS_LEVEL are TYPICAL or ALL. When the FAST_START_MTTR_TARGET is set to a non-zero value, combined with STATISTICS_LEVEL being appropriately set, the advisor is started.