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

• 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

AWR

• Metrics :  Waits
• Metrics : Statistics
• I/O latency fluctuations
• I/O wait histograms
• Redo over weeks
• AWR mining
• Diff’ing AWR reports
• Importing AWR repositories

Redo

• LGWR redo write times (log file parallel write)
• Ratio of Redo bytes to Datablocks writes

Etc

• V$ view time units S,CS,MS,US
• Parsing 10046 traces

SQL

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

VST – vistual sql tunning

• VST in DB Optimizer 3.0
• VST with 100 Tables !
• SQL Joins using sets
• Visualizing SQL Queries
• VST – product design
• View expansion with VST
• Outer Joins Graphically

 

 

 

Kyle Hailey
Uncategorized