top of page

Tuning Blog Entries

  • Writer: kyle Hailey
    kyle Hailey
  • Oct 20, 2011
  • 1 min read

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.

ASH

  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

AWR

Redo

Etc

SQL

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

VST – vistual sql tunning

 
 
 

Comments


Kyle Hailey

  • Facebook
  • Twitter
  • LinkedIn
  • Instagram

San Franisco, Ca 94131

415-341-3430  (please text initially before calling)

bottom of page