Re: Script to automate AWR reports (not snapshots)
- From: Denis <denis.sun@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 3 Mar 2010 13:39:22 -0800 (PST)
Check:
http://damir-vadas.blogspot.com/2009/11/automated-awr-reports-in-oracle-10g11g.html
Yu "Denis" Sun
Oracle DBA
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Sandra Becker
Sent: Wednesday, March 03, 2010 3:55 PM
To: oracle-l
Subject: Script to automate AWR reports (not snapshots)
Platform: IBM z9
OS: SUSE10
Oracle: 10gR2
Management is under the mistaken impression that the performance problems we
are experiencing on a daily basis ALWAYS happen at the same time. To that end,
they want me to set up a shell script that will run an AWR report daily for
each of the two time periods they believe the problems are occuring. I haven't
been able to convince them we should run reports for the times we KNOW we had
problems. I also haven't been able to locate a script to automatically run
reports for the specific time periods--I'm probably not entering the right
search criteria. Does anyone have such a script or can point me in the right
direction?
--
Sandy
Transzap, Inc.
Other related posts:
