Newsgroups: comp.databases.oracle.server Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!enews.sgi.com!newsfeed.mathworks.com!nntp.abs.net!ash.uu.net!newspeer.radix.net!news.er.usgs.gov!news From: Brian Peasland Subject: Re: Alert Log Monitoring / Notification X-Nntp-Posting-Host: edc-cv-60-103.cr.usgs.gov Content-Type: text/plain; charset=us-ascii Message-ID: <404CF94F.CD96E73E@remove_spam.peasland.com> Sender: news@igsrsparc2.er.usgs.gov (Janet Walz (GD) x6739) Content-Transfer-Encoding: 7bit Organization: U.S. Geological Survey, Reston VA X-Accept-Language: en References: Mime-Version: 1.0 Date: Mon, 8 Mar 2004 22:53:03 GMT X-Mailer: Mozilla 4.78 [en] (Windows NT 5.0; U) Lines: 23 Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:256608 Charles Davis wrote: > > All, > > I would like to be notified almost immediately if Oracle 9.2 writes certain > messages to the Alert Log, such as any of the 'unable to extend' messages. > An email sent at the moment of the error would be best. > > Can this be done somehow within Oracle v9.2?? If so, please describe it or > point me to the docs on this. > > I already have an external alert log monitor process, but am looking for > something more immediate that its polling interval. > > Many thanks. > > charles Instead of reinventing the wheel, why not look into Oracle Enterprise Manager's Alerts???? It should do the trick. HTH, Brian