The New Fashion of Oracle Performance Optimization
Oracle debuted the Wait Interface in Release 7.0.12 with only 104 wait events. The number of wait events quickly grew to about 140 in Oracle8.0, about 220 in Oracle8i Database, about 400 in Oracle9i Database, and more than 800 in Oracle Database 10g Release 1. (The actual number of wait events depends largely on your RDBMS configuration and the options that are installed.)
For those of you who have never used the OWI, the growth in the number of wait events with each new release should convince you that the OWI is the preferred tuning methodology. Don’t forget this is not a cheap proposition for Oracle. OWI instrumentation requires the kernel developers to insert counters or sensors in strategic ...
Get Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
