In a Nutshell
In this chapter, we equipped you to deal with wait events that are related to user comments, log buffer, DBWR process, and log files. They are the log file sync, log buffer space, free buffer waits, write complete waits, log file switch completion, and log file switch (checkpoint incomplete) wait events.
The log file sync wait event is related to transaction terminations such as commits or rollbacks.
The log buffer space wait event is related to the log buffer. 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 free buffer waits event is related to the LRU list and DBWR process. Sessions wait on the free buffer waits event when they are unable ...
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.
