Upcoming events : Hotsos Symposium 2012
By Maria Colgan on Feb 17, 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.