The Method R Guide to Mastering Oracle Trace Data

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