make redo log files smaller
increase the size of the checkpoint file
make the changes as per the advice given by MTTR Advisor
make the changes as per the advice given by Checkpoint Advisor
第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 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?()
第3题:
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?()
第4题:
You notice that the performance of the database has degraded because of frequent checkpoints. Which twoactions resolve the issue()
第5题:
In your production database, you have observed that the database server performance degrades whenever there is a switch between the log groups. On further investigation, you find that the database is running in ARCHIVELOG mode and the archived log files are being written to the same disk that is used to store the redo log members. Which two actions would you take to improve the performance of the database server? ()
第6题:
Your database performance has degraded due to frequent checkpointing. What would you do in this scenario?()
第7题:
increase the size of the redo log buffer
increase the number of redo log groups
increase the number of log writer processes
increase the number of ARCn processes
change the appropriate LOG_ARCHIVE_DEST_n parameter to place the archived log files in a separate location
第8题:
the WRITES_LOGFILE_SIZE column of the V$INSTANCE_RECOVERY view
the column of the V$INSTANCE_RECOVERY view
the OPTIMAL_LOGFILE_SIZE column of the V$INSTANCE_RECOVERY view
the LOG_FILE_SIZE_REDO_BLKS column of the V$INSTANCE_RECOVERY view
第9题:
Data blocks have to be written more frequently by DBWR.
Redo blocks have to be written more frequently by LGWR.
You need to substantially increase the size of your database buffer cache to hold the additional checkpoint records.
You need to substantially increase the size of your redo buffer cache to hold the additional checkpoint records.
第10题:
The checkpoint frequency decreases with the smaller redo log file size.
It ensures that all committed data is written to the data files during normal shutdown.
The frequent full checkpoint in a database can cause the overall degradation of the database performance.
It prompts the Checkpoint (CKPT) process to write data to the data files and redo information to the online redo log files.
第11题:
the value of the UNDO_RETENTION initialization parameter
the value of the optimal redo log file size provided by the Redo Logfile Size Advisor
the online redo log files size
the number of redo log members in a group
第12题:
the V$LOG view
the V$DBFILE view
the V$LOGFILE view
the V$INSTANCE_RECOVERY view
Oracle Enterprise Manager Database Control
第13题:
Why can setting too low a value for the FAST_START_MTTR_TARGET parameter reduce your overall database performance?()
第14题:
You notice that the performance of the database has degraded because of frequent checkpoints. Which two actions resolve the issue()
第15题:
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?()
第16题:
Which two statements are true about checkpointing()
第17题:
You are attempting to increase the checkpoint interval on your database. Each of the following choices will affect the duration and/or frequency of checkpoints, except one. Which is it?()
第18题:
What is the implication of setting the initialization parameter FAST_START_MTTR_TARGET to 0 in your database?()
第19题:
Increase the size of redo log files
Increase the size of redo log buffer
Increase the number of redo log files
Place the redo log files on a separate disk
Decrease the number of redo log groups to two
Increate the number Log Writer (LGWR) process
第20题:
Memory Advisor
Segment Advisor
SQL Tuning Advisor
SQL Access Advisor
Automatic Database Diagnostic Monitor (ADDM)
第21题:
The checkpoint frequency decreases with the smaller redo log file size.
It ensures that all committed data is written to the data files during normal shutdown.
The frequent full checkpoint in a database can cause the overall degradation of the database performance.
It prompts the Checkpoint (CKPT) process to write data to the data files and redo information to the onlineredo log files
第22题:
Oracle Enterprise Manager
The V$LOG view
The V$LOGFILE view
The V$FLASHBACK_DATABASE_LOGS view
第23题:
The database performance would be enhanced.
The redo log files would be get filled more frequently.
The overall database performance would be degraded.
The mean time to recover (MTTR) would be increased.