New paper "Mastering Performance with Extended SQL Trace"

Happy New Year.

It’s been a busy few weeks. I finally have something tangible to show for it: “Mastering Performance with Extended SQL Trace” is the new paper I’ve written for this year’s RMOUG conference. Think of it a 15-page update to chapter 5 of Optimizing Oracle Performance.

There’s lots of new detail in there. Some highlights:

• How to enable and disable traces, even in un-cooperative applications.
• How to instrument your application so that tracing the right code path during production operation of your application becomes dead simple.
• How to make that instrumentation highly scalable (think 100,000+ tps).
• How timestamps since 10.2 allow you to know your recursive call relationships without guessing.
• How to create response time profiles for calls and groups of calls, with examples.
• Why you don’t want to be on Oracle 11g prior to 11.2.0.2.0.

I hope you’ll be able to make productive use of it.