Re: Script to automate AWR reports (not snapshots)
Date: Thu, 4 Mar 2010 07:54:29 +0800
Message-ID: <12ee65601003031554qcc23608m988d0067d3ceaf50_at_mail.gmail.com>
Hi Sandra,
You could validate if it's really happening at the same time (or range of time) by having a time series value of your workload.. See the script here
http://karlarao.wordpress.com/2010/01/31/workload-characterization-using-dba_hist-tables-and-ksar/
It shows the significant metrics that you see in AWR reports enough to characterize the workload and tell that there's something going wrong on that period. The report is divided into Capacity,Requirements,and Utilization so you would also know if your server is running out of resources or just waiting or having some bottlenecks (see AAS).
From there you'll detail on the right AWR reports instead of tiresome generation of each, but yes you could automate it. And also you'll hit the right drill down when you use ASH and ADDM...And you could put the values on excel for visualization and for pretty reports... :)
- Karl Arao Blog: karlarao.wordpress.com Wiki: karlarao.tiddlyspot.com -- http://www.freelists.org/webpage/oracle-l