Advanced Oracle 10g Performance Analysis and Tuning with Kyle Hailey, London June 2, 2010

This two-day Oracle 10g Performance Tuning seminar will teach attendees how to fully harness the powerful new performance tuning and diagnostic tools in Oracle 10g.
Attendees will learn techniques in order to gain the necessary skills and knowledge to finally conquer their database woes, thus allowing more time and freedom for you.

Topic 1: OEM 10g Performance Tuning Methodology
As a principle designer for OEM 10g performance monitoring pages, Kyle will explain in depth how to powerfully navigate, read and understand the data and graphs in OEM 10g to quickly identify, analyze and solve performance bottlenecks.

Topic 2: "Average Active Sessions" (AAS)
Attendees will be taught how to find the values or calculate the value of AAS in OEM 10g, AWR, ASH report, and statspack and how to use this value to analyze database performance health and isolate and identify the causes for a performance problem, including calculating the value from statspack data.

Topic 3: Active Session History (ASH)
Attendees will be taught how to analyze ASH data with OEM 10g, ASH report as well as custom SQL scripts. ASH is a dense multidimensional data source and having a toolkit to analyze this data is crucial to harnessing its power.

Topic 4: Wait Events
In this session, we will discuss the causes, explanation and solutions for all the major wait events including the internal structures responsible for the wait events.

Topic 5: Modern Techniques in SQL Tuning
The past few years have seen the emergence of novel SQL tuning techniques such as Oracle's 10g SQL profiles and extended execution statistics, Tuning by Cardinality Feedback, and Oracle's 11g real-time SQL monitoring and plan stability. All these methods will be discussed as well as the newest method to come on the scene, Visual SQL Tuning (VST). VST is a way to visualize SQL statements graphically in order to quickly understand the major components, the flow and the best execution path for a query. Queries are becoming more and more complicated, to the point of being intractable for most humans, but VST makes it much easier to tune even the most complex queries. Find out how VST works and how it can improve your SQL tuning.

In this session, you will learn:

* How to identify problems in a query
* How to identify problems in schema that affect the query
* How to identify candidates for optimal execution path