Hotsos Symposium Speaker – Wolfgang Breitling
Wolfgang Breitling is a returning Hotsos Symposium presenter.
Biography
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 to use that knowledge in tuning. He has shared the findings from this research in papers and presentations at Hotsos Symposia, UKOUG, local Oracle user groups, and other conferences and newsgroups dedicated to Oracle performance topics.
Presentation Title
My SQL Tuning Toolkit: a Guide to Diagnosing Performance Issues
Abstract
This presentation will show the path and steps Wolfgang follows to first identify poorly performing SQL, get their execution plan and then drill down to identify and isolate the part(s) of the plan which are slow.
The difference between explain plan and execution plan will be touched upon.
Along the way, he will share the tools, scripts and methods that he uses every day to help him do that efficiently. And, no, contrary to perhaps popular belief, the 10053 trace is not a tool the Wolfgang uses daily so it will not be part of this presentation.
Presentation Materials
Presentation materials are available online to attendees only.
Schedule
The speaker schedule is as follows: