COUG October 18th Event featuring Wolfgang Breitling from Centrex Consulting Corporation

Speaker: Wolfgang Breitling, Centrex Consulting Corporation

• Wolfgang Breitling is an independent consultant specializing in administering and tuning Peoplesoft on Oracle
• The particular challenges in tuning Peoplesoft, often with no access to the SQL, motivated him to explore Oracle’s cost-based optimizer in an effort to gain a better understanding of how it works and use that knowledge in tuning
• He has shared the findings from this research in papers and presentations at IOUG, UKOUG, local Oracle user groups, and other conferences and newsgroups dedicated to Oracle performance topics

Presentation: Statistics Gathering and Histograms – DOs and DON’Ts

The presentation will show with examples what can go wrong when gathering object statistics
and in particular, but not limited to, when gathering histograms

• Why statistics, even though they are up-to-date and “accurate’, may be wrong for the job – which is to give the optimizer the right information to generate an optimal, or at least adequate, execution plan
• From that we shall try to develop some rules of what to do when, how and how often – and, just as important, what not to

Date: Thursday Oct 18, 2012
—————————————————
Registration: 8:00 am
Presentation: 8:30 am – 9:30 am
—————————————————
Presentation Location:
Bow Valley Square 2
Suite 300, 205 – 5th Ave SW
3rd floor Conference Center – Hamilton Room
—————————————————