Re: Script to automate AWR reports (not snapshots)

From: Andrew Kerber <>
Date: Wed, 3 Mar 2010 15:10:52 -0600
Message-ID: <>

the command line to call an awr report looks like this, you will need to find the two most recent snap ids:

select * from

You may want the html version instead of the text version.

On Wed, Mar 3, 2010 at 3:07 PM, Allen, Brandon <>wrote:

> I think you probably want to start with $ORACLE_HOME/admin/awrrpt.sql,
> but I donít recall for sure if it will accept beginning/end times/snapshots
> as command line parameters, or if you have to run it interactively. Iíve
> only run it interactively and I think that might be the only option, so you
> might have to create your own custom copy if you want to automate it for a
> specified interval. I did the same thing with statspack (spreport.sql)
> once, but not for AWR. Why go to the trouble of automating it though Ė why
> not just run it as needed for troubleshooting this issue, whether itís
> during the same time period or not? It seems like the effort to script the
> automation outweighs the benefit based on the available info.
> Regards,
> Brandon
> ------------------------------
> Privileged/Confidential Information may be contained in this message or
> attachments hereto. Please advise immediately if you or your employer do not
> consent to Internet email for messages of this kind. Opinions, conclusions
> and other information in this message that do not relate to the official
> business of this company shall be understood as neither given nor endorsed
> by it.

Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

Received on Wed Mar 03 2010 - 15:10:52 CST

Original text of this message