The definitive guide to accurate, high-precision measurement of user performance experiences, for Oracle application developers and DBAs. When you want to know where every microsecond of your Oracle-based application's time has gone, there's only one way to find out: tracing. This book is the definitive guide to mastering Oracle trace data. The third edition. Explains how to create Oracle trace files and understand the stories they tell you about your applications and the time they consume. Prescribes a reliable method for optimizing Oracle-based applications throughout all the phases of your software development life cycle. Demonstrates through worked examples how Oracle application developers and database administrators can use Oracle trace data and Method R software to solve and prevent performance problems. Contains more than 50 pages of new material including new worked examples, updated information about production-safe tracing, state-of-the-art techniques for measuring connection pooling applications, and more.

"The first time I used Method R and their software, I made a 6.5-hour query run in less than 11 minutes. In the years since, I've gotten a lot of results like that. I've made a 2-second label scan run in 0.2 seconds, which saved a warehouse team three years' worth of waiting per year. I've proven to a skeptical application vendor that it was the anti-virus software--not Oracle--that was causing a performance problem. And I've saved an international airline over $250,000 on a hardware upgrade that was destined to disappoint them. This book will show you how _you_ can do things like these, too.

" --Guðmundur Jósepsson, CEO, Miracle Iceland.