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.

NB! After a 1.5 year break, this year’s only Advanced Oracle Troubleshooting training class (updated with Oracle 12c content) takes place on 16-20 November & 14-18 December 2015, 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 *