The log file sync wait event in Oracle indicates a session has issued a commit, and the wait time includes writing of the log buffer and the post. Learn how to reduce these waits by batching rows or addressing slow I/O.
Read More
The ASYNC_NETWORK_IO wait indicates that either the session (SPID) is waiting for the client application or there is a network performance issue. Learn how to diagnose and tune for this wait.
Read More
Enqueue wait events are a good indication of locking in Oracle databases. Understanding how Oracle locking works can help you tune for these events.
Read More
When a session waits on the Block Change Tracking Buffer wait event, there’s a wait for space in the CTRW dba buffer. Learn how this impacts performance.
Read More
When a process waits on the Log Buffer Space event, the log buffer is filling up faster than LGWR can write to disk. Learn how this impacts performance.
Read More
By linking database performance to end user experience, respone time analysis can help DBAs and developers deliver significantly improved service.
Read More