Oracle 10g Performance Analysis and Tuning with Kyle Hailey March 22, 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 2.5-hour sessions. (Total: 7.5 hours) Join us for this novel and original Celebrity Seminar right to your desktop.

These highly advanced sessions will cover the following:

Performance Tuning: modern techniques using AAS, ASH and OEM:
23 March 2010 3PM - 5:30PM CET

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 and quickly a 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 through 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.

Wait Events Explained:
24 March 2010 3PM - 5:30PM CET

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 you'll 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".

SQL Tuning: Modern Techniques:
25 March 2010 3PM - 5:30PM CET

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/JjBYW5