top of page
  • Writer's picturekyle Hailey

Tuning Blog Entries

Organizing  some of my past blog entries on Oracle database performance tuning and analysis. I’ll add more notes as well as a separate section on SQL tuning in particular.


  1. SQL execution times from ASH – using ASH to see SQL execution times and execution time variations

  2. AAS on AWR – my favorite ASH query that shows AAS  wait classes  as an ascii graph

  3. CPU Wait vs CPU Usage – seeing OS CPU usage, Oracle CPU usage and Oracle wait for CPU using ASH

  4. Simulated ASH 2.1 – get your ASH for free





  1. Display Cursor Explained – what are all those display_cursor options and what exactly is the data

VST – vistual sql tunning

8 views0 comments

Recent Posts

See All


bottom of page