Upcoming events : OBUG Connect Conference 2012
- by Maria Colgan
The Oracle Benelux User Group (OBUG) have given me an amazing opportunity to present a one day Optimizer workshop at their annual Connect Conference in Maastricht on April 24th. The workshop will run as one of the parallel tracks at the conference and consists of three 45 minute sessions. Each session can be attended stand alone but they will build on each other to allow someone new to the Oracle Optimizer or SQL tuning to come away from the conference with a better understanding of how the Optimizer works and what techniques they should deploy to tune their SQL. Below is a brief description of each of the sessions
Session 7 - 11:30 am Oracle Optimizer: Understanding Optimizer StatisticsThe workshop opens with a discussion on Optimizer statistics and the features introduced in Oracle Database
11g to improve the quality and efficiency of statistics-gathering. The session will also provide strategies for managing statistics in various database
environments.
Session 27 - 14:30 pm Oracle Optimizer: Explain the Explain PlanThe workshop will continue with a detailed examination of the different aspects of
an execution plan, from selectivity
to parallel execution, and explains what information you should be
gleaning from the plan.
Session 47 - 15:45 pm Top Tips to get Optimal Execution Plans Finally I 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.
Hopefully I will see you there!
+Maria Colgan
