CBO Statistics on 11g: How to reduce poorly performing Execution Plans
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.
Carlos Sierra's Tools and Tips 
Hi Carlos,
Will the session be recorded and available for future?
Regards,
Anand
Anand
October 23, 2012 at 7:36 am
Yes Anand. Try this link.
Carlos Sierra
October 25, 2012 at 5:36 pm
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
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
Try this link
Carlos Sierra
October 25, 2012 at 5:33 pm
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
Hi Carlos,
Can you please provide the webscat link?
bhavana
May 16, 2016 at 3:45 pm
I do not have it 😦
Carlos Sierra
June 1, 2016 at 6:06 pm