Re: Script to automate AWR reports (not snapshots)

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Wed, 3 Mar 2010 15:10:52 -0600
Message-ID: <ad3aa4c91003031310l77f1b1dvba2edca41af784b6_at_mail.gmail.com>



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

select * from
table(dbms_workload_repository.awr_report_text(dbid,instance_number,begin_snap_id,end_snap_id))

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

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Mar 03 2010 - 15:10:52 CST

Original text of this message