Hotsos Symposium Speaker – Wolfgang Breitling

Wolfgang Breitling is a returning Hotsos Symposium presenter.

Biography

Wolfgang BreitlingWolfgang 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: