Re: Alert Log Monitoring / Notification

I agree about the Email not being reliable for instantaneous notification.

We have an internal paging system that sends text pages to pagers/beepers. This has been more reliable for a quicker response.

But, in our new global environment, the quicker internal paging system is being dropped for standardizing on Email for such things.

The potentially slower response of Email is considered "less important" when compared to the huge pennies we are going to save :)

-- 

"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message
news:404d9b6b$0$22402$ed9e5944_at_reading.news.pipex.net...


> You will find the start of this if you search google for UTL_FILE and

> ALERT.LOG

>

> I'm not sure that relying on email for almost instantaneous notification

is


> necessarily as reliable as the OP thinks.

>

>

> -- 

> Niall Litchfield

> Oracle DBA

> Audit Commission UK

> "Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message

> news:1078788261.888269_at_yasure...

> > 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

> >

> > Capture the alert log as an external table or read it with UTL_FILE.

> > Then have DBMS_JOB check it from time-to-time an fire of the email

> > using UTL_SMTP.

> >

> > -- 

> > Daniel Morgan

> > http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp

> > http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp

> > damorgan_at_x.washington.edu

> > (replace 'x' with a 'u' to reply)

> >

>

>