| |
Interpreting Parallel Execution Plans
Jonathan Lewis, world-leading Oracle Performance expert & Speak-Tech invite you to a 90-minute “Interpreting Parallel Execution Plans” webinar on Friday, November 22, 2013
When you read an execution plan you’re probably trying to identify the steps that Oracle went through to acquire the final result set so that you can decide whether or not there is a more efficient way of getting the same result.
For a serial execution plan this typically means you have to identify the join order, join methods and access methods together with the point at which each predicate was applied. Generally this isn’t too difficult although there are a few cases where the difference between join order and the order of operation can be slightly obscured.
Parallel execution plans are harder, though, because you really need to understand the impact of the order of operation, distribution mechanisms chosen, and (in recent versions of Oracle) the timing of the generation and use of Bloom filters.
In this presentation we examine the basics of how parallel execution slave work, and the way in which this can result in a massive difference between the join order of an execution plan and the order of operation of the steps of that plan. We learn about “table queues” and how they help us follow the order of operation, and how the distribution method can make a dramatic difference to performance – following which we then learn how to use hints to optimise parallel queries.
If you missed Jonathan's "Basic Cost Based Optimization" in July, or "Basic Optimizer Selectivity" in September, 30-days access to the recordings of one or both of these webinars is available at a special discounted price when combined with your registration for "Interpreting Parallel Execution Plans."
2 Sessions - Choose the one most convenient for you.
November 22, 2013 - 5:00 AM US Pacific, 6:00 AM US Mountain, 7:00 AM US Central,
8:00 AM US Eastern, 1:00 PM BST, 14:00 Central European, 15:00 Eastern European
Register Here
November 22, 2013 - 10:00 AM US Pacific, 11:00 AM US Mountain, 12:00 US Central,
1:00 PM US Eastern, 6:00 PM BST, 19:00 Central European, 20:00 Eastern European
Register Here
Jonathan Lewis is a well-known U.K. based Oracle performance expert with more than 25 years of experience. He’s published three Oracle books – most recently Oracle Core published by Apress Nov 2011, and contributed to three others. Jonathan contributes regularly to newsgroups, forums, User Group magazines, and speaks and gives seminars around the world. Learn more about Jonathan at: http://jonathanlewis.wordpress.com/
Speak-Tech has organized over 100 Oracle training events on DBA and Developer topics like database performance, high-availability, PL/SQL, Oracle Optimizer, Oracle 12c new features and many other topics.
Training by Jonathan Lewis, often called the world's leading Oracle performance expert; Steven Feuerstein, generally considered the world's leading expert in PL/SQL; Syed Jaffar Hussain, Oracle ACE Director awarded the Oracle Excellence Award for Technologist of the year: DBA, 2011 and other experienced experts costs as little as $20 per hour.
Participants learn from home, work or anywhere with internet access. No travel to out-of-town conferences and training - no travel at all, and, best of all, no travel expenses. Since all webinars are recorded, students have access to the same exact material and don't miss anything if they have to leave the webinar to “fight fires," pick up children or any other reason.
John Goodhue is a working DBA in Minneapolis, MN, USA with 20 years of Oracle experience. John recognized the need for high-quality Oracle training by leading experts and started Speak-Tech 10 years ago for that purpose. John served as an Officer of the Twin Cities OUG for 10 years including 2 years as President.
