Re: Alert Log & SQL

From: Ruth Gramolini <rgramolini_at_tax.state.vt.us>
Date: Tue, 19 Sep 2000 10:32:41 -0400
Message-Id: <10624.117350@fatcity.com>

You can download a free package called AlertView from www.zephyrus.com which will allow you to view messages that you select for viewing. It works very well. It runs on a PC.

HTH,
Ruth
----- Original Message -----
From: "Mark Leith" <mark_at_cool-tools.co.uk> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Tuesday, September 19, 2000 11:10 AM Subject: Alert Log & SQL

> 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 Tue Sep 19 2000 - 09:32:41 CDT