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

June 15th Presentation featuring Willie Hardie from Oracle and Ryan Behiel from Veritas

1st Presentation: What’s New in Oracle Database 12c Release 2? Oracle Database 12c has been the most rapidly adopted release in over a decade. In this session we’ll provide a technical introduction to what’s new in Oracle Database 12c Release 2 (12.2) 1st Speaker: Willie Hardie, Oracle Willie Hardie is Vice President of Oracle Database Product […]

Read More
View the Blog »

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 ...

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 ...