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