Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Alert Log & SQL

RE: Alert Log & SQL

From: Mark Leith <>
Date: Tue, 19 Sep 2000 17:06:17 +0100
Message-Id: <>

Thanks for the reply Ruth, but I need (would like anyway:) to do this through SQL if at all possible. The request is by a user of the tool in "Virtual" mode, who wants to know about any new entries to the alert log. They check this every morning on 39 databases across 20 servers manually, but once they have done that any new alerts after say 9:30am - after they have finished - will be missed until the next day..

So if an error does occur on one of these systems, is there anyway via SQL for me to know?

-----Original Message-----
From: []On Behalf Of Ruth Gramolini
Sent: 19 September 2000 16:36
To: Multiple recipients of list ORACLE-L Subject: Re: Alert Log & SQL

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

----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <> Sent: Tuesday, September 19, 2000 11:10 AM

> 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

Author: Ruth Gramolini

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Tue Sep 19 2000 - 11:06:17 CDT

Original text of this message