Working with Automatic Workload Repository Performance Snapshots
Now that we have completed our discussion on the 10G EM Advisors, let’s take an in-depth look at the performance statistics capturing and reporting capabilities provided by 10G EM. Oracle 10G captures performance statistics on a periodic basis and stores the data in the Automatic Workload Repository. The individual statistic capture executions are called AWR Snapshots.
We’ll begin our discussion with a review of the 10G AWR snapshot environment. In a series of upcoming blogs will learn how to use AWR Snapshots to generate performance reports, compare two sets of performance statistics to one another, compare a captured set of statistics to a baseline and finally, how to preserve snapshot sets for future diagnostic use. When we are done with this series, you’ll be saying “Statspack, who needs THAT tired old tool anymore?”