Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Improving redo log writer performance

vittelDec 4 2006 — edited Jul 13 2007
I have a database on RAC (2 nodes)
Oracle 10g
Linux 3
2 servers PowerEdge 2850

I'm tuning my database with "spotilght". I have alredy this alert

"The Average Redo Write Time alarm is activated when the time taken to write redo log entries exceeds a threshold. "

The serveres are not in RAID5.

How can I improve redo log writer performance?


Unlike most other Oracle write I/Os, Oracle sessions must wait for redo log writes to complete before they can continue processing.
Therefore, redo log devices should be placed on fast devices.

Most modern disks should be able to process a redo log write in less than 20 milliseconds, and often much lower.
To reduce redo write time see Improving redo log writer performance.

See Also:

Tuning Contention - Redo Log Files

Tuning Disk I/O - Archive Writer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 10 2007
Added on Dec 4 2006
39 comments
13,073 views