How To Diagnose Random Performance Incidents Using ASH

Given unpredictable workload mixes, even in the cloud environment, rare and random short-lived performance incidents can occur. These incidents present DBAs with a challenge. In this presentation, I begin with why ASH (active session history) is so powerful, how it works and how we use ASH to analyze complex performance incidents. Using only four free scripts, I will lead you step-by-step through the incident analysis process. Plus, I will show you how to visualize a performance situation using the free statistics package R.

Mittwoch, 22.11.2017
12:00 - 12:45

Craig Shallahamer

OraPub, Inc.
Oracle ACE-Director
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.

Weitere Vorträge, die Sie interessieren könnten