Script to automate AWR reports (not snapshots)

From: Sandra Becker <sbecker6925_at_gmail.com>
Date: Wed, 3 Mar 2010 13:54:38 -0700
Message-ID: <3c5f7821003031254i103c63axb26646c6311d42b9_at_mail.gmail.com>



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.

--

http://www.freelists.org/webpage/oracle-l Received on Wed Mar 03 2010 - 14:54:38 CST

Original text of this message