Re: Script to automate AWR reports (not snapshots)
Date: Wed, 3 Mar 2010 15:10:52 -0600
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 <Brandon.Allen_at_oneneck.com>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.
> 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.' -- http://www.freelists.org/webpage/oracle-lReceived on Wed Mar 03 2010 - 15:10:52 CST