Thursday, 20 August 2009

Performance Tuning - Question 042

Which of the following would indicate a performance problem with the redo logs?

A. The EVENT log file parallel write in the V$SYSTEM_EVENT view

B . The EVENT redo log file parallel write in the V$SYSSTAT view

C . The EVENT log file parallel write in the V$SYSSTAT view

D . The EVENT redo log file parallel write in the V$SYSTEM view



Explanation:

Answer A: The wait event log file parallel write indicates that there may be an I/O performance issue. Each of the other answers uses an incorrect wait event, or an incorrectly specified dynamic performance view.

No comments:

Post a Comment