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.
SQL execution times from ASH – using ASH to see SQL execution times and execution time variations
AAS on AWR – my favorite ASH query that shows AAS wait classes as an ascii graph
CPU Wait vs CPU Usage – seeing OS CPU usage, Oracle CPU usage and Oracle wait for CPU using ASH
Simulated ASH 2.1 – get your ASH for free
Display Cursor Explained – what are all those display_cursor options and what exactly is the data
VST – vistual sql tunning