Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning

The Old Fashion of Oracle Performance Optimization

Some say you need to know what life was like in the old days before you can really appreciate the life you now have. This is also true in the world of Oracle performance optimization. Early versions of Oracle did not offer a reliable method to identify performance bottlenecks. Performance optimization was a difficult and complicated task. Everyone used cache hit ratios as the yardstick to monitor database performance. To fully appreciate the OWI tuning methodology, you must be aware of the problems and limitations of the hit ratio–based tuning method. For many of us, this is a trip down memory lane, but for those of you who didn’t grow up in the ratios-based tuning era, you may embrace this as ...