Presentation Title: How the Query Optimizer Learns from it's Mistakes
Speaker: Mr Christian Antognini, OakTable
Company: Trivadis
Presentation abstract: Even though the query optimizer is enhanced with every new release, there are always cases where it makes mistakes. It is therefore critical that it learns from these mistakes automatically. This is exactly what was introduced, starting with 11g, with feedback-based optimization. The aim of this presentation is to review and demonstrate the available features in this area.
Presentation begins: 04/12/2012 13:55
Presentation duration: 45
Presentation content level: 2 (1 = indepth, 5 = strategic overview)
Audience experience: Experienced (2-3 years)
Audience function: Product Expert
Speaker biography: Since 1995, Christian Antognini has focused on understanding how the Oracle database engine works. His main interests include logical and physical database design, the integration of databases with Java applications, the query optimizer and basically everything else related to application performance management and optimization. He is currently working as a senior principal consultant and trainer at Trivadis in Z├╝rich, Switzerland. If Christian is not helping one of his customers get the most out of Oracle, he is somewhere lecturing on application performance management or new Oracle Database features for developers. In addition to classes and seminars organized by Trivadis, he regularly presents at conferences and user-group meetings. He is a proud member of the OakTable Network. Christian is the author of the book Troubleshooting Oracle Performance (Apress, 2008) and the co-author of Der Oracle DBA (Hanser, 2011).
Related topics: Oracle RDBMS: Performance Management
Hall: Hall 8b