oracle: ocp题解与实验(2/205) .

题目：

看exhibit

2. 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 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.

题目答案：D

题目翻译：生产系统中，总的等待时间和日志的并发写入时间非常明显的高，经调查发现有三个redo log groups，每个group有两个成员，所有的group都放在一个磁盘上，你需要做什么工作来缩减等待写入时间？

答案解释：redo log文件需要做并发写入，当然要用多个磁盘来分散io了，集中在一个磁盘上，势必会io吃紧；