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