Blog Posts Videos

Some things you probably didn’t know about Oracle tracing (Chicago edition)

Today, I had the honor of speaking online to the Chicago Oracle Users Group in their “20 in 2020” webinar series. In this presentation, I talk about why it’s OK to trace everything on your system and how to do it safely, and I explain why you’d want to do that in the first place.

Some things you probably didn’t know about Oracle tracing

Topics include:

  • How to trace so that it doesn’t cause problems for anybody
  • What tracing gives you that you can’t get from ASH and AWR
  • Why being able to answer four simple-sounding questions opens up a whole new world for you
  • How to use trace data to answer the questions How long? Why? What if? and What else?
  • How to predict the impact of a proposed change, and why that’s valuable
  • How to diagnose performance problems, even really tricky intermittent ones
  • How to draw a Gantt chart of how your workload fits together, and how this help you solve application inefficiencies

This is an improved version of the DOUG session I presented on 2020-05-07.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.