log buffer space

This wait occurs when the session has to wait for space to become available in the log buffer to write new information. The LGWR periodically writes to redo log files from the log buffer and makes those log buffers available for reuse. This wait indicates that the application is generating redo information faster than LGWR process can write it to the redo files. Either the log buffer is too small, or redo log files are on disks with I/O contention.

Waiting for space in the log buffer because the session is writing data into the log buffer faster than LGWR can write it out. Consider making the log buffer bigger if it is small, or moving the log files to faster disks such as striped disks. Wait Time:

Usually 1 second, but 5 seconds if it is waiting for a Switch Logfile to complete.

Parameters:

None