Thanks to all those who stopped by the demoground yesterday to chat with the Optimizer developers and to check out what is new in Oracle Database 11g. If you haven't had a chance to stop by yet the developers will be there all day today and tomorrow.
To day at Open World we will be giving two sessions on the Optimizer. We will start 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 this 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.
Looking forward to seeing you at our sessions or at the demoground!