Date Event Title Description
11/20/2015 NEOOUG Pittsburgh Seminar Executing Explain Plans and Explaining Execution Plans An overview of DBMS_XPLAN.DISPLAY_CURSOR and a detailed walk through of the output it produces. This presentation will focus mainly on the execution plan section of the output and reveal how to properly make sense of it, a topic that even the Oracle documentation doesn't always get right.
05/14/2014 Great Lakes Oracle Conference SQL Plan Management to the Rescue! What do you do with performance issues where you can't modify the SQL? Or when a query has been running great for months, but you get a call at 2 am that it is not returning? SQL Plan Management to the rescue! SPM is included with Oracle Enterprise Edition 11g or higher. In this session you will learn how it works and walk through a step-by-step process to solve performance issues.
03/03/2013 Hotsos Symposium 2014 SQL Tuning - A Look Behind The Curtain

SQL Tuning - Handout
Strip away all of the magic and mystery of SQL tuning and learn a method that can be used to easily find a performant execution plan for any query, no matter how complex. I will show you how to turn your queries into diagrams that will lead you directly to either an execution plan that will perform well or will show you where the most effective place for an index would be
05/15/2013 Great Lakes Oracle Conference SQL Tuning - A Look Behind The Curtain

SQL Tuning - Handout
Strip away all of the magic and mystery of SQL tuning and learn a method that can be used to easily find a performant execution plan for any query, no matter how complex. I will show you how to turn your queries into diagrams that will lead you directly to either an execution plan that will perform well or will show you where the most effective place for an index would be
04/25/2013 Day-O Executing Explain Plans and Explaining Execution Plans An overview of DBMS_XPLAN.DISPLAY_CURSOR and a detailed walk through of the output it produces. This presentation will focus mainly on the execution plan section of the output and reveal how to properly make sense of it, a topic that even the Oracle documentation doesn't always get right.
04/25/2013 Day-O SQL Tuning - A Look Behind The Curtain

SQL Tuning - Handout
Strip away all of the magic and mystery of SQL tuning and learn a method that can be used to easily find a performant execution plan for any query, no matter how complex. I will show you how to turn your queries into diagrams that will lead you directly to either an execution plan that will perform well or will show you where the most effective place for an index would be
10/18/2012 OOUG Understanding Indexes We will take a look a level deeper than most people's understanding of how indexes work. You will learn how to tell where an index will be most effective, the information that is really stored in an index, and some tricks to get indexes to do things you might not know were possible.
03/30/2012 NEOOUG Executing Explain Plans and Explaining Execution Plans An overview of DBMS_XPLAN.DISPLAY_CURSOR and a detailed walk through of the output it produces. This presentation will focus mainly on the execution plan section of the output and reveal how to properly make sense of it, a topic that even the Oracle documentation doesn't always get right.
03/30/2012 NEOOUG 11 Lingering Myths about Indexes An exploration of a few misconceptions that I still hear about indexes, and how to prove that they are not (always) true
01/20/2011 OOUG Executing Explain Plans and Explaining Execution Plans An overview of DBMS_XPLAN.DISPLAY_CURSOR and a detailed walk through of the output it produces. This presentation will focus mainly on the execution plan section of the output and reveal how to properly make sense of it, a topic that even the Oracle documentation doesn't always get right.