Let's Build Something! Building Your Own ASH Toolkit

• It's all about the right tool for the right job •

Download Now

Let's build something... of value! ASH provides Oracle DBAs with an amazing set of performance data. Because ASH analysis is based on statistics, many DBAs shy away from ASH or use it inappropriately. But once you're in-the-know along with basic dimensional analysis, your performance tuning potential becomes scary-strong.

In this session I'll show you how to build four highly flexible ASH-based scripts; summary, top wait, top cpu and session time-line. I'll even demo the scripts I just created on a real Oracle workload! Whether you use these script or not, you will have a very deep understanding about ASH and how to effectively use it. Plus, some very cool SQL*Plus script build tips.

Search Craig's blog for relevant posts, here.

Related Videos