COUG Members October 21st Presentation


The Anatomy of a SQL Tuning Session

The presentation will lead through the progression of steps of tuning a query.
It is based on the actual process of tuning a SQL to be introduced to production and highlights some of the techniques used to achieve a faster query – all based on the information available from dbms_xplan.display_cursor. No need for a 10046 or 10053 trace.

The steps include
•modifying a view used in the query,
•altering the query itself
and eventually
•some hints.

The query which initially timed out at over 5 minutes ultimately ran in a few seconds.

Speaker: Wolfgang Breitling

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

Prior presentations:

2003 to 2009 Hotsos Symposium on Oracle System Performance
2004, 2005, 2007 to 2009 UKOUG Conference


Please Note: Due to building construction the October presentation location has been revised.

New Location: CGI Group Inc. – Trimac House, Suite 700 – 800 5th Avenue SW (Corner of 8th st and 5th Ave ), 7th Floor
When: Thursday October 21st, 2010.
Registration 8:00 AM, Presentation 8:30 AM, Duration: 1 hour



Long View First4 Amec CGI Devy Oracle O'Reilly SAIT EMC Suncor 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 ...