New to tuning SQL, or maybe this is your 10th year? In this session we will give a quick
intro on SQL and Oracle Optimizer and then provide some specific examples and tips for multiple SQL
tuning options and methods. The goal is for this session to be approachable by all levels of skill and
provide some quick take aways without going too deep into any one area. Example code will be
provided, with some demonstrations.

Learning goals include: What is SQL tuning; What tools should I use; Explain Plan Lies; Statistics +
Histograms = +1; Tuning Advisor + AWR top N SQL = +1; Why do SQL Profiles fail; Create a SQL
Baseline from cursor cache; How to make a SQL Patch; Playing with Optimizer; Why is my index not
being used? (Index clustering)