What action would you take to minimize the waits?

View the Exhibit.
In your production database, the total waits and the time waited for log file parallel write are significantly high. While investigating the reason, you find that there are three redo log groups with two members in each group, and all redo log members are places on a single physical disk.
What action would you take to minimize the waits?
Exhibit:

View the Exhibit.


In your production database, the total waits and the time waited for log file parallel write are significantly high. While investigating the reason, you find that there are three redo log groups with two members in each group, and all redo log members are places on a single physical disk.
What action would you take to minimize the waits?
Exhibit:

A.
start the log writer slave processes

B.
increase the number of redo log files

C.
increase the size of the redo log buffer

D.
place the redo log files on the different disks

E.
increase the number of log writer processes



Leave a Reply 0

Your email address will not be published. Required fields are marked *