Late breaking news - I'll be speaking at the 2010 HOTSOS conference!
Advances in SQL Tuning Techniques
In the past few years some novel SQL tuning techniques have appeared such Oracle 10g’s SQL profiles, 11g's SQL baselines , extended execution statistics, Tuning by Cardinality Feedback, Visual SQL Tuning, Oracle 11g’s real time SQL monitoring and plan stability. Find out what about these methods and how to best harness them easily and effectively on your system.
1) How to identify queries that are potentially suboptimal
2) How to analyze the query
3) What steps to take to come up with an optimal and stable plan