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)
>
Received on Tue Mar 09 2004 - 04:24:43 CST
