Performance and Scalalability Improvements in Oracle 10g and 11g

I have uploaded the slides of my “Performance and Scalalability Improvements in Oracle 10g and 11g” presentation here.

Note that this year’s only Advanced Oracle Troubleshooting class takes place in the end of April/May 2014, so sign up now if you plan to attend this year!

This entry was posted in Oracle and tagged , , . Bookmark the permalink.

2 Responses to Performance and Scalalability Improvements in Oracle 10g and 11g

  1. Noons says:

    Great! Even more plan changes over multiple executions of the same SQL.

    As if we didn’t have enough problems with optimizer plans that change at the whiff of a stat…

    Hasn’t anyone got back to Oracle the clear message that what production environments need is a STABLE and PREDICTABLE optimizer?

    Not something that keeps changing execution plans at the drop of a hat?

    I can’t wait to see what will happen in closed, non-changing environments such as Peoplesoft, JDE, Siebel and even Oracle’s own apps when this ever-changing optimizer is unleashed on them…

    At least give us the option of turning off all this unneeded overhead!

    Ah well: one can only dream…

    Thanks for the superb analysis, Tanel. Much appreciated.

  2. Polarski bernard says:

    Blurring the bondaries between SGA and PGA will quickly poses the question of keeping the definition for thes 2 strucutres. Let me guess, it will be named OGA : Oracle Global Area.

Leave a Reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>