Insights into Statistics, Query Optimization and the Oracle Optimizer

Day 5 of Oracle OpenWorld 2012 October 4th

Maria Colgan
Distinguished Product Manager

Its the last day of Oracle OpenWorld and we have saved the very best for last. So hopefully you are still awake and functioning at this stage!

Today, we present An Insider’s View of How the Optimizer Works (Session CON8457) at Moscone South - room 104. This session explains how the latest version of the optimizer works and the best ways you can influence its decisions to ensure you get optimal execution every time

We really hope you have enjoy the conference so far and will stop by our session this afternoon before you head off home!

Join the discussion

Comments ( 8 )
  • guest Friday, October 5, 2012

    Thanks for the presentation!

    How do we get the slides for the presentation.


  • Senthil Sunday, October 7, 2012

    Unfortunately, I couldn't attend some of the optimizer sessions as I had to leave Thursday afternoon. Are you folks planning to upload all optimizer session presentations to the OOW website for us to view them offline?



  • guest Monday, October 8, 2012

    Unfortunately, the slides presented in session CON8457 will not be shared at this time.

  • guest Monday, October 8, 2012

    Can we get the presentation "Optimizer Hints". We are unable to download from OOW website.


  • guest Wednesday, October 10, 2012

    When are the slides presented at OOW2012 be shared?

  • guest Monday, October 22, 2012

    You can download the slide from on "Optimizer Hints" are https://oracleus.activeevents.com/connect/sessionDetail.ww?SESSION_ID=8455

    There is a link on the right hand side of the page to get the PDF.



  • dbsnake Tuesday, October 30, 2012

    Hi, Maria, I am your fans. Can you send the slide of "CON8457 - Oracle Database Optimizer: An Insider’s View of How the Optimizer Works " to me? I want to look at it for a long time (since I came back from OOW 2012). I missed your session for some reason, very regret. My email address is allantreycn@yahoo.com.cn

  • guest Tuesday, October 30, 2012

    The presentation on Optimizer hints is informative .

    couple of slides on sqlprofiles could have been added

    to this since it uses hints internally and text normalization is

    possible using force match .



Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.