Upcoming events : Hotsos Symposium 2012

I have been lucky enough to be invited to the tenth annual Hotsos Symposium in Irving Texas on March 4-8. The Hotsos Symposium differs from other Oracle conferences because it is a dedicated Oracle performance conference and attracts some of the top performance speakers like, Tom Kyte, Cary Millsap, and Jonathan Lewis. If you get a chance you should really check it out. I have two sessions at this years symposium:

Inside the Oracle 11g Optimizer
With every new release of the Oracle Optimizer and the statistics that feed it are enhance in the hope of producing more optimal execution plans. Navigating the new features and behavior changes can be a daunting task for a developer and a DBA. This session describes what changes were made in the Optimizer in 11g and how you can take advantage of the new features to achieve more optimal execution plans.

Tips to Prevent Suboptimal Execution Plans
In this session I use how-to examples to answer questions like why an index wasn't used, why partition eliminations did not occur, why statistics were ignored, and many more. You will learn to identify and quickly resolve these issues without the need for optimizer hints or changing initialization parameters.

Hope to see you there!

+Maria Colgan

Comments:

Hi Maria,

During one of your sessions at the Hotsos Symposium 2012, I had asked a question about when the optimizer will/will not perform transitive closure, and you replied that you didn't have those details in your cache at the moment - would you be able to provide some more details when you get a chance in the near future?

Thanks.

Posted by Steve on March 12, 2012 at 10:54 AM PDT #

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