Log Buffer Space

Possible Causes:

This wait occurs because you are writing the log buffer faster than LGWR can write it to the redo logs, or because log switches are too slow. To address this problem, increase the size of the log files, or increase the size of the log buffer, or get faster disks to write to. You might even consider using solid-state disks, for their high speed.

Actions:

• Put log files on faster disks.
• Look at tuning checkpoint or archive processes (log files switches).
• Review application design, use NOLOGGING operations where appropriate, and avoid changing more data than required.
• Finally, check refresh methods when using Materialized Views to reduce logging activity.