Oracle 10g Performance Analysis and Tuning with Kyle Hailey

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:

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 any kind of performance problem and Active Session History (ASH) provides the detailed drill down information to analyse and resolve it. 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 you a performance-tuning guru or if you already are one how they can make your life easier.

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'.

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 looks at modern tuning techniques based on dbms_xplan.display_cursor and extend rows source statistics, and explains tuning by cardinality feedback and visual SQL tuning.

When you register for this event it will appear you are booking for an event on the first day only. This is not an error but due to constraints within our booking system. Please do proceed with your booking and you will in fact receive the access details for all 3 days.

• Discover how AAS, ASH and OEM can make you a performance-tuning guru or if you already are one how they can make your life easier
• Learn how to deal with 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, latch:cache buffer
• Learn modern tuning techniques based on dbms_xplan.display_cursor and extend rows source statistics, and about tuning by cardinality feedback and visual SQL tuning