Live Virtual Seminar! Oracle 10g Performance Analysis and Tuning with Kyle Hailey June 21, 2010

What you will learn:
Oracle University is proud to present our online Celebrity Seminars series. This is a unique opportunity to attend an online Seminar with one of Oracle's most experienced Database experts consisting of three, consecutive, in depth two and half hour sessions. (Total: seven and half hours) Join us for this novel and original Celebrity Seminars right from your desktop.

These highly advanced sessions will cover the following:
Day 1: 3PM – 5:30PM CET - Performance Tuning: modern techniques using AAS, ASH and OEM:

Average Active Sessions (AAS), a single metric new on version 10g of Oracle, allows easy monitoring and bottleneck detection of Oracle instances. AAS identifies clearly an quickly an kind of performance problem and the detailed drill down information to analyze and resolve any performance issue is provided by Active Session History (ASH). ASH and AAS can be easily harnessed though OEM 10g or via scripts and other tools. In this session find out how AAS, ASH and OEM can make a you a performance tuning guru or if you already are one how they can make your life easier.

Day 2: 3PM – 5:30PM CET - Wait Events Explained:
AAS and ASH are based upon the foundation of the Oracle Wait Interface. Oracle waits describe almost all possible bottlenecks in Oracle. In this session find out how to deal with the top 10 Oracle wait events from simple IO wait events such as "db file sequential reads" to more complex issues such as "buffer busy waits" and "latch: cache buffers chains".

Day 3: 3PM – 5:30PM CET - SQL Tuning: Modern Techniques :
AAS and ASH are good at finding system bottlenecks and identifying badly performing SQL, but once a badly performing SQL is found, what steps can be taken to improve the SQL performance. This session explains modern tuning techniques based on dbms_xplan.display_cursor, extend rows source statistics, tuning by cardinality feedback and visual SQL Tuning.

Official Website: http://cli.gs/hA2A2j