Oracle Performance Tuning Methodology with Kyle Hailey

This course will teach attendees how to fully harness the powerful performance tuning and diagnostic tools in Oracle Database 10g and 11g.

In this class, students will learn how to use the Oracle Enterprise Manager performance page, most notably how to interpret the “average active session” (AAS) chart to identify problems and then how to drill down to find resolution either through the Automatic Database Diagnostic Monitor (ADDM) or through direct investigation of the data in the drilldowns. Students will learn an invaluable lesson by learning what AAS is, how to interpret it, how see identify a problem and how to drill down for further analysis and resolution.

However, unlike most performance classes, this training will provide students with advanced detail on how the data is collected, aggregated, displayed and analyzed. This advanced knowledge will deepen the student’s understanding, giving students the ability to manually collect and analyze performance data independently of the Oracle tools and features. This is particularly useful for persons tuning Oracle when auto-data collection is not available for example on Oracle Standard Edition.

The training will include detailed explanations, analysis and solutions of the top wait events. Some of these solutions are only possible with the revolutionary data collection technique of “active session history” (ASH). As with AAS, the training will demonstrate how to collect ASH manually on any version of Oracle and how to analyze the collected data to solve performance bottlenecks.

In summary, students will gain the necessary skills and knowledge to finally conquer their database woes, thus allowing more time and freedom while still looking brilliant to management and end-users.

Why should you attend this seminar?

To learn a repeatable solid that can be used for every database performance issues and will lead to finding their solutions.

Audience
Course Topics Enterprise Manager performance monitoring and tuning pages v$active_session_history AWR and Statspack reports ASH reports Average Active Sessions Wait Events Internal database structures that impact wait events and visual SQL tuning
Course Objectives

• The seminar will present a method of understanding
• identifying and solving Oracle database performance issues starting from a global perspective on database load and drilling down into the wait events and internal database structur
• the seminar will also spend time on a methodology for analyzing SQL query performance and how to identify optimal SQL execution paths