What is this?
The log buffer space wait event occurs when server processes
are waiting for free space in the log buffer, because you are writing redo
to the log buffer faster than LGWR can write it out.
What actions can be taken?
Modify the redo log buffer size. If the size of the log buffer is already
reasonable, then ensure that the disks on which the online redo logs reside
do not suffer from I/O contention. The log buffer space wait
event could be indicative of either disk I/O contention on the disks where
the redo logs reside, or of a too-small log buffer. Check the I/O profile
of the disks containing the redo logs to investigate whether the I/O system
is the bottleneck. If the I/O system is not a problem, then the redo log
buffer could be too small. Increase the size of the redo log buffer until
this event is no longer significant.
|