Size of redo logs
Number of datafiles
LOG_CHECKPOINT_INTERVAL
LOG_CHECKPOINT_TIMEOUT
第1题:
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?()
第2题:
You are adding redo logs to the Oracle database. Creating a new redo log adds information to which of the following Oracle resources? ()
第3题:
You are analyzing the components of the redo log mechanisms in your Oracle database. Which of the following purposes does the CKPT process serve?()
第4题:
Which three initialization parameters are no longer needed when FAST_START_MTTR_TARGET is defined?()
第5题:
You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup information of your database. Which file can be used as a repository to store information regarding the RMAN backup?()
第6题:
Why can setting too low a value for the FAST_START_MTTR_TARGET parameter reduce your overall database performance?()
第7题:
You notice that the performance of the database has degraded because of frequent checkpoints. Which two actions resolve the issue()
第8题:
You can control instance recover performance by setting parameters to define targets for()
第9题:
You notice that the performance of the database has degraded because of frequent checkpoints. Which twoactions resolve the issue()
第10题:
You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-file autobackups. Which files are not backed up during the RMAN backup?()