Oracle Database 10g: Advanced Oracle 10g Performance Analysis And
Tuning With Kyle Hailey

Product Description

This Oracle 10g Performance Tuning course will teach attendees how to fully harness the powerful new performance tuning & diagnostic tools in Oracle Database 10g.

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 & 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 & how to drill down for further analysis & resolution.

However, unlike most performance classes, this training will provide students with advanced detail on how the data is collected, aggregated, displayed & analyzed. This advanced knowledge will deepen the student's understanding, giving students the ability to manually collect & analyze performance data independently of the Oracle 10g tools & features. This is particularly useful for persons tuning Oracle when auto-data collection is not available (for example Oracle 8i, 9i, 10g Standard Edition, or Enterprise Edition without the Management Packs installed).

The training will include detailed explanations, analysis & solutions of the top 30 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 (even Oracle 9i) & how to analyze the collected data to solve performance bottlenecks.

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

This training may be available onsite; please contact us if you are interested.