What to expect from the Optimizer team at Oracle Open World 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.

Comments:

Post a Comment:
  • HTML Syntax: NOT allowed
About

The Oracle Optimizer blog is written by members of the Optimizer development team. The goal of this blog is to provide an insight into the workings of the Optimizer and the statistics it relies on. The views expressed on this blog are our own and do not necessarily reflect the views of Oracle and its affiliates. The views and opinions expressed by visitors on this blog are theirs solely and may not reflect ours.

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today