Disable automatic checkpoint tuning.
Check the size of the redo log file size and increase the size if it is small.
Set the FAST_START_MTTR_TARGET parameter as per the advice given by the MTTR Advisor.
Decrease the number of redo log members if there are more than one redo log members available in each redo log group.
第1题:
You observe that database performance has degraded over a period of time. While investigating the reason, you find that the size of the database buffer cache is not large enough to cache all the needed data blocks. Which advisory component would you refer to, in order to determine the required size of the database buffer cache?()
第2题:
You work as a database administrator for Certkiller .com. Users in the Certkiller PROD database complain about the slow response when accessing the database. In the Active Session Waiting: Configuration page you find that the majority of the wait time is for the redo log buffer.Further investigation using the Run Queue graph and operating system tools reveals that the redo log files are on the same disks, and that the disk I/O for the redo log files is the reason for the performance degradation. Which two actions would you take to gain performance?()
第3题:
A.TARGET_REDO_BLKS
B.FAST_START_IO_TARGET
C.LOG_CHECKPOINT_TIMEOUT
D.RECOVERY_ESTIMATED_IOS
E.LOG_FILE_SIZE_REDO_BLKS
F.LOG_CHECKPOINT_INTERVAL
第4题:
In the parameter file of your production database, the FAST_START_MTTR_TARGET parameter is set to 300 to optimize instance recovery. While observing the performance of the database during instance recovery, you find that the redo log files are not sized properly to support this activity. Which two sources could you use to determine the optimal size of the redo log files?()
第5题:
You are maintaining your OLTP database in Oracle10g. While observing the performance of the database, you find that the log switch occurs more than once for every 20 minutes, affecting the database performance. Which factor is responsible for frequent log switches?()
第6题:
A user receives the following error while executing a query: ORA/x7f01555:snapshot too old Which two options can be the solutions to avoid such errors in future?()
第7题:
Why can setting too low a value for the FAST_START_MTTR_TARGET parameter reduce your overall database performance?()
第8题:
Which statements are true about checkpointing()
第9题:
You notice that the performance of the database has degraded because of frequent checkpoints. Which two actions resolve the issue()
第10题:
You are maintaining your database in Oracle10g. You have set the value of the STATISTICS_LEVEL initialization parameter to TYPICAL and the value of the FAST_START_MTTR_TARGET parameter to 900 seconds. To increase the performance of the database, you want to determine the log file size that should equal the minimum size of all the online redo log files. Which column will enable you to perform the desired task?()