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

November 23rd Presentation Featuring Alex Kizer, Groundswell Group

Presentation: Introduction to NoSQL & MongoDB Database The term “NoSQL” is very ill-defined. It’s generally applied to a number of recent nonrelational databases such as MongoDB, Cassandra, Neo4J, and Redis. They embrace schema-less data, run on clusters, and have the ability to trade off traditional consistency for other useful properties. Advocates of NoSQL databases claim […]

Read More
View the Blog »

September 21st Presentation Featuring Sarah Craynon Zumbrum, Oracle

Presentation: Introduction to Oracle Analytics Cloud (OAC) Oracle’s analytics offering got a huge boost this spring with the release of the ...

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