Oracle Performance DownloadWait Event Tips

Understanding Wait-Events and database errors is essential for effective performance management. As an expert in wait time analysis, Confio offers information on Wait-Events for Oracle and Wait Types for SQL Server databases and provides tips for common ORA errors. Check back often for new wait time information.

Oracle Wait Events

ORA Error Tips

SQL Server Wait Types
Log Buffer Space ORA-12154 WRITELOG
Block Change Tracking Buffer ORA-06502 OLEDB
Locking and Enqueue   PAGEIOLATCH_EX
Oracle RAC Wait Events   CXPACKET
Read By Other Session   ASYNC Network IO
Index Block Split    
RO Enqueue    
File Open    
Control File Reads & Writes    
PL/SQL Lock Timer    
Log File Switch Completion    
Direct Path Read Temp    
Log File Sync    
Buffer Busy Waits    
Row Cache Lock Wait    
Latch Free    

 
Problems with your database performance? Monitor database reponse time. Free trial. Results in 30 minutes.
Learn More
Oracle SQL Server DB2 Sybase