Skip to main content



Database server

developerWorks

General DB2 Informix Oracle
   Recommendations  |   Performance papers

Initialization parameters used for Oracle I/O option measurements
Miscellaneous settings
Selecting the test scenario
I/O options
Relink Oracle for async I/O

Miscellaneous settings

When the statspack reports 'log file sync' as one of the top 5 wait events then a significant performance improvement is to

  • increase the log buffers
  • put the redo log files to a separate storage unit, e.g. another rank or another storage server

Team
Please address any comments to the performance team: linux390@de.ibm.com