Hotsos Symposium Speaker – Kyle Hailey

Kyle Hailey is a returning Hotsos Symposium presenter.

Biography

Kyle HaileyKyle Hailey, along with John Beresniewicz, recently redesigned the Oracle Enterprise Manager 10g performance pages to be graphically oriented and wait interface centric. Kyle has a long and distinguished career with Oracle having worked at Oracle in support, porting, benchmarking, and kernel development. He has also worked at Quest and Embarcadero as well as many other companies in the industry on performance tuning and optimization of Oracle. He has designed various tools to improve high end performance monitoring such as direct SGA attach and interactive graphic displays of performance data. He has spoken at previous Hotsos Symposia, NoCOUG, RMOUG, NYCOUG, Oracle World, and DB Forum as well as taught classes around the world on Oracle performance tuning. Currently, he works at Embarcadero.

Presentation Title

Modern Approaches to SQL Tuning

Abstract

Mr. Hailey will discuss the following topics:

  • EXPLAIN PLAN — review
  • ERSS — extended rows source statistics
  • TCF — tuning by cardinality feedback
  • VST — visual SQL tuning
  • RTSM — real time SQL monitoring
  • Hints vs Outlines vs Profiles vs SQL Plan Baselines
  • Plan variation and plan stability

Presentation Materials

Presentation materials are available online to attendees only.

Schedule

The speaker schedule is as follows: