Re: Alert Log & SQL

I don't know of any way to use SQL to get this information (other than collecting it and putting it in a table as someone else suggested). However if you are looking for specific events (such as errors), in 8i you can establish system-wide event triggers that will notify the appropriate people when something happens. I would not try this in 8.1.5, however, based on my own experience. I had a trigger that looked for ORA-600s and notified the DBAs by email. Unfortunately there was a bug in 8.1.5 that caused core dumps when there were other errors, especially unhandled exceptions. So the bottom line is that this is a good approach as long as you are on 8.1.6 and up.

Regards,
Chris Gait

On 19 Sep 2000, at 7:10, Mark Leith wrote:

> Gurus,
>
> Is it possible to establish whether there has been any new entries, or in
> fact just read the Oracle alert log with SQL?
>
> The reason - We have a tool that can monitor the alert log when it has an
> agent which is local to the instance, and will in fact alert on any new
> entries. If the tool does not have a local agent though, this function
> becomes invalid.
>
> We can however set up a User Defined Collection to monitor this if we can
> return some value with SQL. Does Oracle store anywhere that it has written
> to the file? If so what does it store, and how can I query the database?
>
> All help appreciated..
>
> Mark Leith
> =================
> Cool Tools UK Ltd
> +44 1905 330 281
Received on Wed Sep 20 2000 - 06:37:34 CDT