Update on Oracle Open World

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!

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