QUESTION 352:
In your production environment:
- the database is running in ARCHIVELOG mode
- there are three online redo log groups
- there are two members in each group that are placed on different disks
- the archived redo log files are placed on disks other than the disks where the members
of online redo log groups are placed
While performing transactions, users complain that transactions take a long time to
complete. On investigation, you find that the STATUS column of the V$LOG data
dictionary view shows the value ACTIVE, for two of the online redo log groups, thus
causing the performance to be degraded.
Which action would you perform to increase the performance?
A. increase the number of members in each online redo log group
B. increase the number of online redo log groups
C. increase the number of LogWriter (LGWR) processes
D. increase the size of the redo log buffer
Answer: B
------------------------------------------------------------------
请各位看看 为什么选B呢