Re: awr history

From: Daniel W. Fink <>
Date: Thu, 13 Jan 2011 09:16:14 -0700
Message-ID: <>

All AWR and ASH data is stored in the database (or memory in the case of recent ASH data), so you can query it just like an ordinary table/view (assuming proper licensing of course).

AWR views are named DBA_HIST*
ASH (in memory) is v$active_session_history

If you are not already acquainted with the analytical functions in sql, learn them. They are very handy for analyzing AWR/ASH (even statspack) data. You can trend, profile, forecast and check for variances.

In terms of graphing, SQLDeveloper has some limited graphing capabilities. I often take the output from SQLDeveloper, save it in xls format, then graph in Excel. I *think* Application Express can do some charting as well, but I've never worked with it.

On 1/12/2011 6:21 PM, ed lewis wrote:
> Hello,
> I'm looking for a way to query the AWR, and ASH tables
> to create customized reports. I would also like to present
> some of the results in graphs.
> Can anyone recommend any sources for this ?
> Scripts, websites, or 3rd party tools.
> Thanks in advance.
> Ed
> No virus found in this incoming message.
> Checked by AVG -
> Version: 9.0.872 / Virus Database: 271.1.1/3375 - Release Date: 01/12/11 00:38:00

Received on Thu Jan 13 2011 - 10:16:14 CST

Original text of this message