Oracle Latch Free Wait Event
The latch free wait event occurs when a session tries to get a latch but fails because another session has it. Learn how this wait causes performance issues.
Read MoreMost Popular Databases
Oracle Log Buffer Space Wait Event
The log buffer space wait event occurs when server processes write data into the log buffer faster than the LGWR process can write it out. Learn more.
Read MoreSQL Server WRITELOG Wait Type
WRITELOG wait types in SQL Server can indicate bottlenecks in the disk where the transaction log is stored or inefficient use of transactions. Learn how to tune for this wait type.
Read MoreOracle PL/SQL Lock Timer Wait Event
The PL/SQL lock timer wait event can indicate issues with application response, throughput and possibly coding. Learn more.
Read MoreOracle RAC Wait Events: gc cr request, gc buffer busy acquire and gc buffer busy release
The special use of a global buffer cache in Oracle RAC makes it critical to monitor inter-instance communication via the cluster-specific wait events gc cr request and gc buffer busy. Learn more.
Read MoreOracle Read By Other Session Wait Event
Read by Other Session events in Oracle indicate contention for hot blocks or objects. To tune for this, you can redistribute data from hot blocks, adjust PCTFREE and PCTUSED values, reduce the block size or optimize indexes.
Read MoreOracle Log File Sync Wait Event
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 MoreSQL Server ASYNC Network IO Wait Type
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 MoreUnderstanding Oracle Locking and Enqueue Waits
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 MoreOracle Block Change Tracking Buffer Wait Event
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 MoreOracle Log Buffer Space Wait Event
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 MoreResponse Time Analysis: How to Improve Database Performance by Measuring User Experience
By linking database performance to end user experience, respone time analysis can help DBAs and developers deliver significantly improved service.
Read More