log buffer space
The log buffer space wait event has no wait parameters. In Oracle Database 10g, this wait event falls under the Configuration wait class. Keep the following key thoughts in mind when dealing with the log buffer space wait event.
Sessions wait on the log buffer space event when they are unable to copy redo entries into the log buffer due to insufficient space.
The LGWR process is responsible for writing out the redo entries and making room for new ones.
Common Causes, Diagnosis, and Actions
In addition to the log buffer space wait ...
Get Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
