What action would you take to minimize the waits?

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?
PassCertification.com- 1z0-043 Exam Questions and Answers 2

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?
PassCertification.com- 1z0-043 Exam Questions and Answers 2

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 *