Reminder: You must sign up for each Deep Dives session that you want to attend separately. See the utoug.org/Deep-Dives for a link to each session registration.
Session Title: Tuning Oracle Using Advanced Active Session History (ASH) Strategies
Presenter: Craig Shallahamer
Session Date: August 30th
Session Time: 8am - 12pm - Lunch will be served at noon
There is a better way to solve your most difficult Oracle performance problems. Some performance issues are literally impossible to solve using an AWR Report or Oracle's time model. ASH comes to the rescue!
Even DBAs who are familiar with ASH have a difficult time using ASH to directly answer key management issues surrounding a performance incident. Craig will teach you how to weave your ASH analysis into a compelling "who done it" mystery complete with good guys, bad guys, motive and even the weapon!
You will be able to:
- Understand the benefits of both time-based analysis and an ASH sample-based analysis
- Pinpoint when an incident began, when it ended, who was involved and what they were doing
- Jumpstart your analysis using OraPub's free BloodHound and Scratchpad ASH tool kits
- Create a chart to visualize an incident at a point-in-time
- Develop an incident time-line to explain the mystery
- Watch and listen to Craig as he demonstrates the analysis process multiple times
Session 1. When to use and how to use ASH
Session 2. Incident analysis mastery
Session 3. Visualizing an incident with ASH and R
As this is a hands-on seminar, the best case is students can connect to one of their very active Oracle systems. If a remote system is not available, a local database must be available on the students laptop. Craig will provide scripts to create "interesting" loads so the ASH analysis can occur. Also, to download, install and use R an internet connection is required.
The analysis scripts will not impact a production system in any way; no DDL, no DML or heavy SELECTS.
Craig is a long time Oracle DBA who specializes in Oracle tuning and started the OraPub website in 1995. Craig is a performance researcher and blogger, consultant, author of two books, an enthusiastic conference speaker and a passionate teacher to thousands of Oracle professionals. He clearly pushes the teaching envelope with his video seminars and webinars! Craig has received a number of technical, effectiveness and community involvement awards. Craig is also an Oracle ACE Director.