File Library

ASH and AWR Performance Data
Topic: The Database
Owner: Kellyn Gorman
Date: 2013-05-23
Subtopic: Tips and Techniques

With the introduction of the Automatic Workload Repository in Oracle 10g, a new world of performance data was introduced to the Database Administrator and Developer.
With appropriate licensing, ASH and AWR data is ever present as key performance information to assist in diagnosing issues and tracking resource usage of database environments. This session will take the database specialist through an introduction to ASH and AWR concepts, then move on to architecture, reports, including advanced reporting that is only available through the command line.
The session will end with a extensive demonstration of queries showing how to properly query ASH performance data directly.

Download File   PAPERkpotvin.ashawrperformancedata.pdf

Become a member of ODTUG to gain access to more than 12,500 files in our technical database.

  • Not a member? Click through to the topic of interest to browse a list of available presentations.
  • Already a member? Log-in here to access the full database

Click here to see the Full Techincal Resource Database