Re: Script to automate AWR reports (not snapshots)
- From: Karl Arao <karlarao@xxxxxxxxx>
- To: sbecker6925@xxxxxxxxx
- Date: Thu, 4 Mar 2010 07:54:29 +0800
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
--
//www.freelists.org/webpage/oracle-l
Other related posts: