From oracle-l-bounce@freelists.org Wed Nov 2 12:26:37 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id jA2IQbs4021572 for ; Wed, 2 Nov 2005 12:26:37 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id jA2IQZvX021559 for ; Wed, 2 Nov 2005 12:26:35 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 439C7214876; Wed, 2 Nov 2005 13:26:30 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 23645-04; Wed, 2 Nov 2005 13:26:30 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id BE90121481D; Wed, 2 Nov 2005 13:26:29 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 02 Nov 2005 13:24:37 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9D0F6214822 for ; Wed, 2 Nov 2005 13:24:37 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 23250-08 for ; Wed, 2 Nov 2005 13:24:37 -0500 (EST) Received: from sccrmhc14.comcast.net (sccrmhc14.comcast.net [63.240.77.84]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 40A002147EE for ; Wed, 2 Nov 2005 13:24:37 -0500 (EST) Received: from 204.127.205.147 ([204.127.205.147]) by comcast.net (sccrmhc14) with SMTP id <2005110218242101400emeqse>; Wed, 2 Nov 2005 18:24:21 +0000 Received: from [155.104.239.16] by 204.127.205.147; Wed, 02 Nov 2005 18:24:21 +0000 From: ryan_gaffuri@comcast.net To: dba.orcl@gmail.com, oracle list Cc: Sami Seerangan Subject: Re: Daily Heath report script Date: Wed, 02 Nov 2005 18:24:21 +0000 Message-Id: <110220051824.3161.436904550006422F00000C592200762194079D9A00000E09A1020E979D@comcast.net> X-Authenticated-Sender: cnlhbl9nYWZmdXJpQGNvbWNhc3QubmV0 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="NextPart_Webmail_9m3u9jl4l_3161_1130955861_0" X-archive-position: 27963 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: ryan_gaffuri@comcast.net Precedence: normal Reply-To: ryan_gaffuri@comcast.net X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Level: X-Spam-Status: No, hits=-3.6 required=5.0 tests=AWL,BAYES_00,HTML_MESSAGE, MIME_BOUND_NEXTPART,MIME_HTML_NO_CHARSET,NO_REAL_NAME autolearn=no version=2.63 --NextPart_Webmail_9m3u9jl4l_3161_1130955861_0 Content-Type: text/plain Content-Transfer-Encoding: 8bit i recommend a script to go out and poll the alert log. Copy yesterdays alert log. diff it with todays alert log, then look for error messages. if anything comes up email it out. this way you dont have to check it. We had this setup to run every 5 minutes on my last project. -------------- Original message -------------- We want to setup daily email notification about database issues/alerts & warning levels. Say for example % free space in each tablespace, hanging sessions, replication queue count, broken jobs,locked accounts, and many other --NextPart_Webmail_9m3u9jl4l_3161_1130955861_0 Content-Type: text/html Content-Transfer-Encoding: 8bit

i recommend a script to go out and poll the alert log. Copy yesterdays alert log. diff it with todays alert log, then look for error messages. if anything comes up email it out.

this way you dont have to check it. We had this setup to run every 5 minutes on my last project.

-------------- Original message --------------
We want to setup daily email notification about database issues/alerts & warning levels.
Say for example % free space in each tablespace, hanging sessions, replication queue count, broken jobs,locked accounts, and many other

--NextPart_Webmail_9m3u9jl4l_3161_1130955861_0-- -- http://www.freelists.org/webpage/oracle-l