OraPub's One-Day 2010 Performance Seminar
for advanced DBAs
OraPub's One-Day 2010 Performance Seminar was created specifically for
experienced DBAs and is squarely focused on advanced Oracle performance
analysis. To develop the seminar, OraPub surveyed the most experienced students
in the firefighting
and advanced
analysis courses and specifically asked what
were the most memorable, valuable, and relevant aspects of the courses. The
results were stunning, consistent, and clear.
The seminar content reflects this feedback, combined with Craig's recent
research and consulting engagements. We have distilled both the firefighting and
advanced analysis courses to their core, refined the material, updated it, and
created this power-packed one-day experience. You will leave the course with
advanced technical skills enabling you to be a much better Oracle performance
analyst. Plus, the price is significantly† reduced.
If you find it difficult to get away from the office, or your training and
travel budgets have evaporated, yet you still want to learn and propel your
career forward—this is the seminar for you.
What makes this seminar unique?
- What you learn can be immediately applied and demonstrated to your management.
- The content has been selected from OraPub's most advanced students.
- Delivered by Craig Shallahamer,
well-known Oracle performance expert and author.
- It's a practical and insightful weaving of internals, method, and advanced performance analysis.
- We offer a 100% money back guarantee! There is no fine print.
Target Audience and Required Skills:
This is an advanced class for Oracle DBAs, therefore you should be very familiar
with Oracle's architecture and performance tuning. Due to the one-day class
structure, the class moves quickly and there will be little time to delve into
off-topic discussions or quickly fill a knowledge gap. If you have read the
book, Oracle
Performance Firefighting and/or feel you are very comfortable with
the contents, then you will be fine. If you are still not sure, feel free to
contact OraPub.
This seminar is not a substitute for OraPub's classroom environment courses. Our
classroom courses offer many advantages that a one day seminar simply cannot,
such as in-depth discussions, more personal conversations, lots of hands-on
work, less intense atmosphere, and personal Q&A with Craig. But with shattered
IT budgets, this may be just what you need!
Duration: 1 full day (9 am-12 noon, 1 pm-5 pm)
Seminar Objectives:
- Learn about the many methods Oracle uses to gather performance data, their
advantages and limitations, and how the analyst retrieves and uses this data.
- Analyzing Resource Consumption: Learn how to measure network, CPU, and IO
consumption and when possible their capacity limit using both Oracle and
non-Oracle data sources.
- Mapping the Terrain: Learn how to create a map of the performance terrain
enabling advanced analysis including how to visualize the situation and extract
insightful solutions.
- Computing System Behavior Analysis: Learn how a specific performance
solution affects the relationship between the user experience, application work
completed, and resource utilization.
- Resolving the Free Buffer Waits Event: Learn how to resolve the complex wait
events "free buffer waits" by delving into Oracle
internals and applying the previous seminar content.
This is a very practical yet deep internals seminar, filled with amazing
discoveries about how Oracle works. We hope you can join us!
Detailed Seminar Agenda:
(click to collapse/expand)
Analyzing Resource Consumption
Oracle processes consume various resources in
various quantities. Advanced analysis requires quantifying the resources
consumed and relating that to both competing processes and the resource capacity limit.
This module will focus on quantifying network and CPU consumption, and when
possible their capacity limit. Both Oracle and non-Oracle performance data
sources will be explored.
Mapping the Terrain
Every man (and women) needs a good map. Craig will present how
to create a map of the performance situation and where to get the data you need.
The result is an exposed root cause, where solutions likely exist, and what you can
expect from these solutions. The map (you'll develop during the exercises) can
be shown visually, numerically, and graphically. Templates will be used along
with real production performance data so a real and repeatable process results.
Computing System Behavior Analysis
Here's the situation: All
experienced DBAs have a pretty good idea of which performance solutions are the
best. But in talking with DBAs, there is an uncomfortableness about, for
example, how tuning affects the relationship between the user experience,
application work completed, and resource utilization. For example, why would CPU consumption decrease
when there is more logical IO activity? This module explores these relationships
and how the experienced DBA can use them to develop a greater understanding of
computing systems and specifically Oracle systems.
Resolving the Free Buffer Waits Event
This year we chose to include a module specifically on the wait event, free buffer waits.
This event is
intriguing because it requires the perfect storm of a struggling database writer, specific types of SQL,
buffer cache configuration, and server process activity to manifest.
Understanding this wait event is fascinating because it touches the very
deepest parts of the Oracle architecture; the least recently used lists, the
dirty lists, how blocks are brought into the buffer cache, and buffer
"movement." Fortunately, with so many causes to this problem there are also many
solutions. This module focuses squarely on resolving free buffer waits by
developing a clear understanding of the relevant Oracle internals and solution
development focusing on tweaking Oracle, the application (including the SQL),
and the IO subsystem. This is a very practical yet deep internal presentation,
filled with amazing discoveries about how Oracle works.
†
The seminar price varies based on the
offering location and local Oracle User Group involvement. For location specific
pricing, go to either
our registration page and click on your desired location or contact your local
Oracle user group.
|
OraPub courses are designed and delivered by Craig Shallahamer, author of:
|
|
|
|
|
|