Received: (qmail 14056 invoked from network); 3 Mar 2010 15:09:40 -0600 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by static-ip-85-25-126-90.inaddr.intergenia.de with SMTP; 3 Mar 2010 15:09:29 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 03D90CD9934; Wed, 3 Mar 2010 16:09:28 -0500 (EST) X-Virus-Scanned: Debian amavisd-new at localhost.localdomain Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id krJ8YiiEi7a9; Wed, 3 Mar 2010 16:09:27 -0500 (EST) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 3F273CD98E3; Wed, 3 Mar 2010 16:08:45 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 03 Mar 2010 16:08:03 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8B82CCD98A6 for ; Wed, 3 Mar 2010 16:08:03 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id WHoMlevDNafn for ; Wed, 3 Mar 2010 16:08:03 -0500 (EST) Received: from smtp.oneneck.com (dot089host.oneneck.net [63.226.42.89]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id F1B03CD98A5 for ; Wed, 3 Mar 2010 16:08:02 -0500 (EST) Received: from ONEWS06.oneneck.corp ([172.20.4.14]) by ONEWS05.oneneck.corp ([::1]) with mapi; Wed, 3 Mar 2010 14:08:01 -0700 From: "Allen, Brandon" To: "sbecker6925@gmail.com" , oracle-l Date: Wed, 3 Mar 2010 14:07:59 -0700 Subject: RE: Script to automate AWR reports (not snapshots) Thread-Topic: Script to automate AWR reports (not snapshots) Message-ID: <64BAF54438380142A0BF94A23224A31E114486F8CE@ONEWS06.oneneck.corp> References: <3c5f7821003031254i103c63axb26646c6311d42b9@mail.gmail.com> In-Reply-To: <3c5f7821003031254i103c63axb26646c6311d42b9@mail.gmail.com> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: acceptlanguage: en-US Content-Type: multipart/alternative; boundary="_000_64BAF54438380142A0BF94A23224A31E114486F8CEONEWS06onenec_" MIME-Version: 1.0 X-archive-position: 26269 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: Brandon.Allen@OneNeck.com Precedence: normal Reply-To: Brandon.Allen@OneNeck.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l --_000_64BAF54438380142A0BF94A23224A31E114486F8CEONEWS06onenec_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable 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 onl= y run it interactively and I think that might be the only option, so you mi= ght have to create your own custom copy if you want to automate it for a sp= ecified 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 t= he same time period or not? It seems like the effort to script the automat= ion outweighs the benefit based on the available info. Regards, Brandon ________________________________ Privileged/Confidential Information may be contained in this message or att= achments hereto. Please advise immediately if you or your employer do not c= onsent to Internet email for messages of this kind. Opinions, conclusions a= nd other information in this message that do not relate to the official bus= iness of this company shall be understood as neither given nor endorsed by = it. --_000_64BAF54438380142A0BF94A23224A31E114486F8CEONEWS06onenec_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

I think you probably want to start with $ORACLE_HOME/admin/a= wrrpt.sql, but I don’t recall for sure if it will accept beginning/en= d times/snapshots as command line parameters, or if you have to run it interactively.   IR= 17;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 t= rouble of automating it though – why not just run it as needed for tr= oubleshooting 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 Info= rmation may be contained in this message or attachments hereto. Please advi= se 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 b= usiness of this company shall be understood as neither given nor endorsed b= y it.
 --_000_64BAF54438380142A0BF94A23224A31E114486F8CEONEWS06onenec_-- -- http://www.freelists.org/webpage/oracle-l