| |
|
|
|
|
|
|
|
|
Wednesday, August 15th 2012 |
|
|
|
|
|
8:00 AM - 8:30 AM |
|
Check-In and Complimentary Breakfast |
|
|
|
|
|
|
|
|
|
8:30 AM - 10:00 AM |
|
Session 1 - How to find execution paths |
|
|
|
|
There are several different methods for generating, or examining, execution paths, from the simple autotrace in SQL*Plus through to interrogating the dynamic performance views such as v$sql_plan_statistics_all in great detail. The different methods have their own strengths and weaknesses, and these vary with version of Oracle. In this first session, we discuss the different options, what's visible in them, and to choose the most appropriate one for the task in hand. |
|
|
|
|
|
|
|
|
|
10:00 AM - 10:30 AM |
|
Break |
|
|
|
|
|
|
|
|
|
10:30 AM - 12:00 PM |
|
Session 2 - Interpreting Plans |
|
|
|
|
Once you've got an execution plan, how do you decide what it means? An often-quoted clue is that 'it starts near the top and over to the right'. This hint is a consequence of a simple algorithm for reading execution plans - no matter how complex - in a fashion that can be described in just two steps. |
|
|
|
|
|
|
|
|
|
12:00 PM - 12:45 PM |
|
Complimentary Lunch |
|
|
|
|
|
|
|
|
|
12:45 PM - 2:15 PM |
|
Session 3 - Problems with Plans |
|
|
|
|
Although there are several ways of acquiring execution plans, none of them is perfect. Some options simply omit critical details; some options are unable of guaranteeing the truth. In this session, we look at the various omissions and errors that can make you jump to the wrong conclusion when you are trying to understand how a query might run. |
|
|
|
|
|
|
|
|
|
2:30 PM - 4:00 PM |
|
Session 4 - Advanced Features |
|
|
|
|
Once you have mastered the standard features of execution plans, you can easily extend your understanding to any new feature that Oracle throws at you. In this session, we take a look some of the features that are not seen so commonly in production systems, namely, distributed joins, parallel execution, and partitioned tables. |
|
|
|
|
|
|
|
|
There are no seminars on the
calendar at this time.
View all Seminars |
