Re: awr history
Date: Thu, 13 Jan 2011 09:16:14 -0700
Message-ID: <4D2F254E.1080206_at_optimaldba.com>
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 - www.avg.com
> Version: 9.0.872 / Virus Database: 271.1.1/3375 - Release Date: 01/12/11 00:38:00
>
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jan 13 2011 - 10:16:14 CST