Wait 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

Log Buffer Space Block Change Tracking Buffer Locking and Enqueue Oracle RAC Wait Events Read By Other Session 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

SQL Server Wait Types

WRITELOG OLEDB PAGEIOLATCH_EX CXPACKET ASYNC Network IO SQL Server sp_addmessage System Stored Procedure SQL Server SOS_SCHEDULER_YIELD Wait Type SQL Server NETWORKIO Wait Type SQL Server DBCC LOG Command SQL Server Buffer Cache Hit Ratio SQL Server DTC Wait Type

ORA Error Tips

ORA-12154 ORA-06502

VMware Tips

Host Disk Latency Host Exit Standby Error Host Network Redundancy Degraded No Host for Secondary VM Alarm: VMware Fault Tolerance Non-ESX Datastore Workload Oracle VMware and SQL Server on VMware Tips: Overloaded Storage Secondary VM Needed: VMware Fault Tolerance Slow Storage Timeout Starting Secondary VM VM Active Memory Usage VM CPU Percent Usage VM Disk Bus Resets VM Disk Commands Aborted VM High Availability Error VM High Availability Reset VM Memory Ballooning VM Memory Swapping VM Memory Swapping VM Overloaded Storage Alarm VMware CPU Ready Time VMware Cluster High Availability Error VMware Host CPU Saturation VMware Host Connection Failure VMware Host Dropped Packets VMware Host Memory Usage VMware License User Threshold