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

Read More

Leave a Reply

May 18th Presentation Featuring Ray Smith from CGI

Presentation: RMAN “RMAN is ok for the simple recoveries but when things get complicated it’s just not good enough.” Anyone who’s been a DBA for any length of time has heard that statement but is it fair? This presentation is intended to assess RMAN’s ability to recover in various recovery scenarios and discuss the alternative in […]

Read More
View the Blog »

March 16th Presentation Featuring Martin D’Souza from Innovation at Insum

Presentation: APEX 5.1 New Features APEX 5.1 is the latest major release of Oracle Application Express. It has a lot of ...

February 16th Presentation featuring Steve Recsky from First4 Database Partners Inc.

Presentation:Oracle - Free Extended Support was to on May 31, 2017. It is now the end of December 2018 ...