Striving for Optimal Performance
  • Blog
    • Archive
    • Categories
    • Search
  • Troubleshooting Oracle Performance
    • Description
    • Structure
    • Table of Contents
    • Forewords
    • Reviews
    • Downloadable Files
    • Addenda and Errata
    • First Edition
  • Public Appearances
    • Past Public Appearances
  • Contact
  • About

Query Optimizer 11g – What’s new?

2 December 2008 4 Comments Written by Christian Antognini

Today I presented at the DOAG Conference in Nuremberg. As the title of this post suggests, I talked about the query optimizer features introduced in Oracle Database 11g. This is an evolution of the paper I already presented at the UKOUG Conference in Birmingham, at the Hotsos Symposium in Dallas, at the AOUG Expertentreff in Vienna, and at the TrivadisOPEN in Zürich. The aim of this short post is to point out that I just uploaded the presentation and the demo associated to it under Publications.

11gR1, Query Optimizer, Speaking
DBMS_XPLAN.PREPARE_PLAN_XML_QUERY
Automatic Evolution of SQL Plan Baselines

4 Comments

2 Pings/Trackbacks

  1. Primi test con 11g « Oracle and other Primi test con 11g « Oracle and other
    3 December 2008    

    […] 2008 di Cristian Cudizio Stamattina nel mio RSS feed reader (si dice così?) è comparso un nuovo post di Christian Antognini. Oggi sono arrivato in ufficio molto presto per un’attività; terminata l’attività […]

  2. Michael Seiwert Michael Seiwert
    10 December 2008    

    Hi Christian, I’d like to congratulate for your great talk at the DOAG conference! You mentioned at the conference that you are working on projects where Oracle and EJB and ORM is involved. If I had a wish which talk I want to hear at next years DOAG conference then it would be a talk about JEE / Oracle “best practices”.

    Reply
  3. Christian Antognini Christian Antognini
    10 December 2008    

    Hi Michael

    Thank you for your feedback and the idea for next year!

    Cheers,
    Chris

    Reply
  4. Test con Oracle 11g: parte III « Oracle and other Test con Oracle 11g: parte III « Oracle and other
    16 December 2008    

    […] fine però per riprodurre il comportamento descritto da Christian Antognini ho dovuto utilizzare due metodi alternativi: hint oppure parametro optimizer_mode=first_rows_100. […]

  1. Primi test con 11g « Oracle and other on 3 December 2008 at 13:49
  2. Test con Oracle 11g: parte III « Oracle and other on 16 December 2008 at 13:27

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.