• UTOUG Deep Dives - Tuning Oracle Using Advanced Active Session History (ASH) Strategies

UTOUG Deep Dives - Tuning Oracle Using Advanced Active Session History (ASH) Strategies

  • August 30, 2017
  • 8:00 AM - 12:00 PM
  • Intermountain Medical Center - Doty Education Center, 5131 Cottonwood Street, Murray, Utah
  • 3


Registration is closed

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

Organization: OraPub

Session Date: August 30th

Session Time: 8am - 12pm - Lunch will be served at noon

Session Abstract:

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

Class Outline

Session 1. When to use and how to use ASH

Session 2. Incident analysis mastery

Session 3. Visualizing an incident with ASH and R

Student Requirements

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.

Speaker Bio:

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.

© Utah Oracle Users Group (UTOUG)
Powered by Wild Apricot Membership Software