Carlos Sierra's Tools and Tips

Tools and Tips for Oracle Performance and SQL Tuning

A healthy approach to optimizer statistics: 11g improvements and common concerns you should know about

with 5 comments

Have you ever wondered what is the “right way” to gather statistics for the Optimizer? Well, actually there is no “right way”. When someone asks me “how should we gathered statistics?”, my answer always is: “it all depends”.

Mauro Pagano is presenting at the Central Florida Oracle Users Group (CFOUG) meeting this coming Monday, July 23 at 6:00 PM, in Orlando, Florida. His topic is: “A healthy approach to optimizer statistics: 11g improvements and common concerns you should know about”. This presentation covers interesting features in 11g, but most important: what works well and what works almost well when it comes to statistics gathering. Mauro is one of the best engineers supporting query tuning (QTUNE) at Oracle. At his present role, he has seen many issues concerning statistics. Thus Mauro has a pretty good idea of what works best and  in which conditions. He will also talk about common misconceptions and mistakes.

If you are in the Central Florida area, please contact the CFOUG to attend this valuable session. Power point will be available through the CFOUG web page after the presentation.


Written by Carlos Sierra

July 20, 2012 at 4:52 am

5 Responses

Subscribe to comments with RSS.

  1. Hi Carlos,

    where can I download or review this presentation? Thanks in advance .



    November 3, 2012 at 4:42 pm

    • For Mauro’s Webcast on CBO Statistics:
      look for MOS 1456176.1 or 1477381.1

      Carlos Sierra

      November 5, 2012 at 7:04 am

  2. Thanks Carlos , I got the CBO document .
    Can you please help me to download A healthy approach to optimizer statistics: presentation .


    November 5, 2012 at 2:55 pm

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: