Advanced Oracle 10g Performance Analysis and Tuning with Kyle Hailey

Total time

Advanced Oracle 10g Performance Analysis and Tuning with Kyle Hailey

Oracle University
Logo Oracle University
Provider rating: starstar_borderstar_borderstar_borderstar_border 2 Oracle University has an average rating of 2 (out of 1 reviews)

Need more information? Get more details on the site of the provider.

Starting dates and places

There are no known starting dates for this product.

Description

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:
  • 23 March 2010 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 identi…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Didn't find what you were looking for? See also: Oracle 10G, Oracle, Programming (general), IT Security, and Retail (Management).

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:
  • 23 March 2010 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 and quickly the 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 you a performance tuning guru or if you already are one how they can make your life easier.
  • 24 March 2010 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".
  • 25 March 2010 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

PLEASE NOTE: When you register for this event it will appear you are booking for an event on the 26th of November 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 details for access to all 3 events. A Live Virtual Class (LVC) is exclusively for registered students; unregistered individuals may not view an LVC at any time. Registered students must view the class from the country listed in the registration form. Unauthorized recording, copying, or transmission of LVC content may not be made. This Live Virtual Seminar will not qualify you for our free headset campaign. The price includes all 3 sessions listed above.


Audience
Course Topics
Course Objectives
There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate $1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.