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 · Reyjkavík, Iceland