Oracle Explain Plan with Jonathan Lewis - 1 Day Seminar

Learn from Jonathan Lewis, a reknowned expert on the underpinnings of the Oracle database engine. Jonathan is the author of two books, Practical Oracle 8i - Building Efficient Databases, and Cost-Based Oracle Fundamentals, and a co-author of Oracle Insights: Tales of the Oak Table If you've never heard Jonathan speak, you're in for a treat.

The different methods of generating execution paths, from autotrace to explain to v$sql_plan_statistics_all in great detail and how to choose the right method.
How to read execution plans - no matter how complex - in a fashion that can be described in just two steps.
The various omissions and errors that lead to the wrong conclusion when trying to understand how a query might run.
Extending understanding of features such as distributed joins, parallel execution, and partitioned tables.