Oracle
1Z0-043 · Question #13
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…
The correct answer is D. place the redo log files on the different disks. See the full explanation below for the reasoning.
Question
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
Options
- Astart the log writer slave processes
- Bincrease the number of redo log files
- Cincrease the size of the redo log buffer
- Dplace the redo log files on the different disks
- Eincrease the number of log writer processes
How the community answered
(60 responses)- A7% (4)
- B2% (1)
- C3% (2)
- D77% (46)
- E12% (7)
Community Discussion
No community discussion yet for this question.