Spotlight on Oracle – Improving Redo Log Writer Performance (SOO15)

Improving Redo Log Writer Performance

Redo logs contain details of transactions that may not yet have been written to the data files. The primary purpose of the redo logs is to allow for the recovery of the database in the event of a system or database failure.

This section covers:

• Redo log configuration
   
• Optimizing archiving
   
• Log file wait events