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

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