What action would you take to minimize the waits?

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?

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?

A.
start the log writer slave processes

B.
increase the number of redoes 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 *