RE: Script to automate AWR reports (not snapshots)
From: Allen, Brandon <Brandon.Allen_at_OneNeck.com>
Date: Wed, 3 Mar 2010 14:07:59 -0700
Message-ID: <64BAF54438380142A0BF94A23224A31E114486F8CE_at_ONEWS06.oneneck.corp>
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.
Date: Wed, 3 Mar 2010 14:07:59 -0700
Message-ID: <64BAF54438380142A0BF94A23224A31E114486F8CE_at_ONEWS06.oneneck.corp>
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.
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Mar 03 2010 - 15:07:59 CST