By Maria Colgan-Oracle on Sep 08, 2013
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.