Insights into Statistics, Query Optimization and the Oracle Optimizer

Oracle OpenWorld 2012 Call For Papers

Maria Colgan
Distinguished Product Manager

I can't believe it's time once again to start thinking about Oracle OpenWorld! The Oracle OpenWorld 2012 call for papers opens March 14th. Oracle customers and partners are encouraged to submit proposals to present at this year's Oracle OpenWorld conference, which will be held September 30 - October 4, 2012 at the Moscone Center in San Francisco. Details and submission guidelines are available on the Oracle OpenWorld Call for Papers web site. The deadline for submissions is April 9th 2012 at 11:59 pm PDT. We look forward to checking out your sessions on the Optimizer, SQL Plan Management, and statistics!

Join the discussion

Comments ( 1 )
  • guest Thursday, May 31, 2012

    In your presentation you mentioned that one should use xplan instead of "explan plan for" since the latter can give the wrong plan.

    Can you give an example of this where:

    1. no bind variables are used

    2. all statistics are up to date

    All the examples I've seen so far use bind variables or have really bad statistics.

    Thank you!

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