Re: Alert Log Monitoring / Notification

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)