Oracle Wait Event Tuning: Optimization with Oracle Wait Interface and Wait Event Analysis

This handbook provides database administrators with clear and concise processes with which to attack tuning problems using Oracle Wait Interface. A guide is provided to demonstrate the mechanics of the Wait Interface and how to use it not only to tune database performance at the database level but also to give the statistics needed to understand problems that lie outside of the database in the SAN or the network. Techniques that apply to tuning any Oracle database from version 7 through 9i and beyond are included.

This handbook provides database administrators with clear and concise processes with which to attack tuning problems using Oracle Wait Interface. A guide is provided to demonstrate the mechanics of the Wait Interface and how to use it not only to tune database performance at the database level but also to give the statistics needed to understand problems that lie outside of the database in the SAN or the network. Techniques that apply to tuning any Oracle database from version 7 through 9i and beyond are included.

Stephen Andert is a database administrator for First Health Group Corporation. He has written articles on SQL*Loader tuning and has presented at local and international Oracle user group events. He is an Oracle8 and Oracle8i Oracle Certified Professional and is currently serves on the board of AZORA, the Arizona Oracle user group. He lives in Chandler, Arizona.