Re: Script to automate AWR reports (not snapshots)

From: Dan Norris <>
Date: Wed, 3 Mar 2010 16:02:52 -0600
Message-ID: <>

Read the comments in the top of the $OH/rdbms/admin/awrrpti.sql script. It tells you exactly how to set the proper variables so that you can call it without prompting. From there, you can automate it as needed.

I've used this method to run AWR reports for each instance of a RAC environment from a single location (instead of having to login to each instance) because instance id is a variable you can pass in.


On Wed, Mar 3, 2010 at 2:54 PM, Sandra Becker <> wrote:

> 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.

Received on Wed Mar 03 2010 - 16:02:52 CST

Original text of this message