What to expect from the Optimizer team at Oracle Open World 2010
By Maria Colgan on Aug 06, 2010
Oracle Open World, the largest gathering of Oracle customers, partners, developers, and technology enthusiasts will happen in September (19-23) when Oracle will host its annual user conference in San Francisco. And the Optimizer development group will be there!
You have multiple opportunities to meet the team, either at one of our technical sessions, or at the Oracle Demo grounds. This year the Optimizer team has 3 technical session, all of which build from one another. We will start on Tuesday morning at 11 am with the Explain the Explain plan session (session S316955 Moscone South/Rm 104), where we will examines the different aspects of an execution plan, from selectivity to parallel execution, and explains what information you should be gleaning from the plan.
Then on Tuesday afternoon at 3:30 pm we will build on what you learned in the morning session when we present Top tips for getting optimal SQL execution all the time (session S317019 Moscone South/Rm 103). This session will show you how to identify and resolving the most common SQL execution performance problems, such
as poor cardinality estimations, bind peeking issues, and selecting the
wrong access method.
Finally Wednesday morning at 11:30 am you get an opportunity to put what you learned at both of the technical presentations to good use when you join us for our first ever hands on lab, Explain Plan: How to read and Analyze Execution Plans (Session S318755 Marriott Marquis/Salon 10 / 11). In this hands on lab you will get to solve 4 SQL tuning problems using the techniques described in the technical sessions.
The Optimizer development team will also be at the Oracle demo grounds (Monday through Wednesday) to answer all of your burning questions and to demonstrate the latest 11g features.