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 18.104.22.168.0.