Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 29563 invoked from network); 13 Nov 2007 13:22:17 -0600 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by 69.64.49.119 with SMTP; 13 Nov 2007 13:22:17 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 89DB77B79A9; Tue, 13 Nov 2007 14:22:17 -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 27242-01; Tue, 13 Nov 2007 14:22:17 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 029097B7994; Tue, 13 Nov 2007 14:22:16 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 13 Nov 2007 13:35:50 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 3AEE77B6AD6 for ; Tue, 13 Nov 2007 13:35:50 -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 18655-03 for ; Tue, 13 Nov 2007 13:35:50 -0500 (EST) Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.187]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D0BE37B6AEB for ; Tue, 13 Nov 2007 13:35:49 -0500 (EST) Received: by nf-out-0910.google.com with SMTP id 4so1198410nfv for ; Tue, 13 Nov 2007 10:35:48 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=JxcKnIIpSLD3GwrCTDmQPDjyTVOZAoBQscpodmnYU1g=; b=GDyHMeeYAoGpsNuTMhK6Vgy4mYFoRUBgG6zTtJiAKkQ4lZ0rP7l0I9WTu3NVbMImPW9LA47ufBxNxdMh210HSEn77KpdNTlLrHeXyzHjnwM2ZHE1jEA+bdALTEfxJHhi1fTrArMsTKhm2KbudC+6JMum2/OihKWLSQYSDXXY1Kg= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=bkNVa/FWIX9tO+1aauKaeuGtLYGkrA/21v+Op8KhjLnaMgTMXT988TjupPYokRSo/PolUDl0zKMKvVgTVNmiZqKzvZvCZ5M6S9Vpev0ApH19eYsTEC0I7Zpq/Hwd/K1cziT2tXZZ5HhkWbKsziTEmgHHhB3seGpnY9HoFkV+n8M= Received: by 10.78.179.12 with SMTP id b12mr7078878huf.1194978947397; Tue, 13 Nov 2007 10:35:47 -0800 (PST) Received: by 10.78.192.17 with HTTP; Tue, 13 Nov 2007 10:35:47 -0800 (PST) Message-ID: <2ead3a60711131035s2ea050afx1493e9824cf45df3@mail.gmail.com> Date: Tue, 13 Nov 2007 10:35:47 -0800 From: "John Kanagaraj" To: prem.khanna@eds.com Subject: Re: Automate AWR report in Grid control Cc: oracle-l@freelists.org In-Reply-To: <20104CEE0E12EB4BA40AEAD6C12753A32FEC84@inpnm231.apac.corp.eds.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Disposition: inline References: <20104CEE0E12EB4BA40AEAD6C12753A32FEC84@inpnm231.apac.corp.eds.com> X-archive-position: 3212 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: john.kanagaraj@gmail.com Precedence: normal Reply-to: john.kanagaraj@gmail.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 X-Virus-Scanned: Debian amavisd-new at localhost.localdomain Prem, > Have anyone tried to automate AWR report in grid control ? > For example, I need to automate AWR report generation for a couple of > databases everyday between 7 to 10 AM . I am assuming that you are seeing an issue around this time? If so, why not look at ADDM reports for that period first to see if anything pops up. I am assuming you have the License to do this: If you are licensed to look at AWR data, then you are automatically licensed to look at ADDM data. ADDM reports are automatically generated at the end of every AWR report and are made available from the GUI. You can alternately query the DBA_ADVISOR_% tables directly to avoid CTD. -- John Kanagaraj <>< DB Soft Inc http://www.linkedin.com/in/johnkanagaraj http://jkanagaraj.wordpress.com (Sorry - not an Oracle blog!) ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** -- http://www.freelists.org/webpage/oracle-l