Insights into Statistics, Query Optimization and the Oracle Optimizer

Oracle OpenWorld 2013 - Time to plan your schedule

Maria Colgan
Distinguished Product Manager

There are only two weeks to go until Oracle Open World, the largest gathering of Oracle customers, partners, developers, and technology enthusiasts, which begins on September 22nd in San Francisco. Of course the Optimizer development group will be there and you will have multiple opportunities to meet the team, in one of our technical sessions, or at the Oracle demogrounds.

This year the Optimizer team has 2 technical sessions;

  • Monday, September 23rd at 3:15pm  Oracle Optimizer: What’s New in Oracle Database 12c?
    Session CON8622
    at Moscone North - room 131
    This session provides a deep-dive explanation of how the new adaptive approach to query optimization works. We will use a real-world demo to show the different components of the adaptive model and how they help the optimizer learn additional information during query execution that can be used to improve not only the performance of the current SQL statement but all statements.

  • Tuesday, September 24th at 5:15pm Oracle Optimizer Bootcamp: 10 Optimizer tips you can't do without
    Session CON8643 at Moscone South - room 104
    Jonathan Lewis will join us to explain the process of analyzing and solving 10 of the most common SQL execution performance problems. These problems include poor cardinality estimates, bind peeking issues, the selection of sub-optimal access methods, and many more. Through clear how-to examples, you will learn how to identify and quickly resolve these issues and add 10 new tricks to your SQL tuning arsenal.

If you have burning Optimizer or statistics related questions, you can ask them at the Optimizer demo booth in the Database area of the demogrounds. Members of the Optimizer development team will be there Monday to Wednesday from 9:45am until 5:30pm. You may even be able to pick up an optimizer bumper sticker.

The full searchable OOW catalog is on-line, or you can browse the speakers by name. So start planning your trip today!

Be the first to comment

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