Carlos Sierra's Tools and Tips

Tools and Tips for Oracle Performance and SQL Tuning

CBO Statistics on 11g: How to reduce poorly performing Execution Plans

with 11 comments

Today, October 23 at 4:00 pm GMT (London time), Mauro Pagano will be presenting an interesting topic in CBO Statistics from Support perspective: what works and what almost works. This presentation is not that much about explaining features, but more about sharing Mauro’s experience regarding CBO Statistics. As many of you know, Mauro is one of the top Oracle resources when it comes to SQL Tuning hands-on within the Query Tuning team at Oracle Support.

This Webinar has registered over 600 participants, and I would not be surprise many more will join today. If you are interested please try to pre-register since the Webinar closes when it reaches 1000 participants.

Webinar will start at 4:00 pm GMT (London), 8:00 am San Francisco time, 11:00 am eastern time (Orlando!).

I (Carlos Sierra) will be there answering posted questions. Abel Macias and Steve Dixon will also join to help Mauro answering questions, which we expect to come in large numbers during the Webinar. This is a hot topic, since poor CBO Statistics causes more SQL to perform poorly than any other factor.

Link to register: WebEx

I hope you can attend live. If you cannot make it, you can always review the recording after a few days.

Advertisements

Written by Carlos Sierra

October 23, 2012 at 6:49 am

Posted in Statistics

11 Responses

Subscribe to comments with RSS.

  1. Hi Carlos,

    Will the session be recorded and available for future?

    Regards,
    Anand

    Anand

    October 23, 2012 at 7:36 am

  2. Hi Carlos,

    First, many thanks for writing the sqlt/ sqlhc – i palyed with it today and i was – wow!!

    I have few questions, if you ok with that:

    a) the sqlt/sqlhc both requires diagnostic/ tuning pack for AWR to provide detailed info. Is anything which provide same amount of detail using statspack? Unfortunately Oracle didn’t provide the chance to have AWR on SE

    b) is any note which i should follow daily to get the schedule for all this great webinars presented by top experts?

    Cheers,
    Dany

    DanyC

    October 23, 2012 at 6:23 pm

    • Dany,
      SQLT and SQLHC would read data from AWR but not from StatsPack. No particular reason. I never got to add StatsPack due to other priorities.
      To look for future Webinars you may want to look at MOS 1456176.1
      Cheers — Carlos

      Carlos Sierra

      October 25, 2012 at 5:36 pm

      • Thanks for coming back on this..
        Would you fancy adding StatsPack (although is no longer on Oracle roadmap) as i’m sure will be useful for many customers/ users due to the current license limitation on AWR and honestly i don’t see many shops to migrate soon to EE (for a guy like you this could be done as Friday project – and don’t think will take more then few days) 🙂

        Many thanks,
        Dani

        DanyC

        October 26, 2012 at 2:27 pm

      • I will add it to the list, but there are many other request ahead of it…

        Carlos Sierra

        October 29, 2012 at 8:13 am

  3. Hi Carlos,
    when ready (few days), where can I download or review this presentation?
    thanks in advance.
    Ciao
    Alberto

    Alberto Frosi (@Albertofro)

    October 24, 2012 at 5:46 am

  4. I think this is among the most important information for me. And i’m glad reading your article. But want to remark on some general things, The web site style is great, the articles is really excellent : D. Good job, cheers

    test website

    March 17, 2013 at 8:54 am

  5. Hi Carlos,

    Can you please provide the webscat link?

    bhavana

    May 16, 2016 at 3:45 pm


Leave a Reply

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

WordPress.com Logo

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

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

%d bloggers like this: