Message-Id: <10624.117345@fatcity.com> From: "Mark Leith" Date: Tue, 19 Sep 2000 14:59:49 +0100 Subject: Alert Log & SQL This is a multi-part message in MIME format. ------=_NextPart_000_0016_01C0224A.422D4040 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit 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 mark@cool-tools.co.uk ------=_NextPart_000_0016_01C0224A.422D4040 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Gurus,
 
Is it = possible to=20 establish whether there has been any new entries, or in fact just read = the=20 Oracle alert log with SQL?
 
The = reason - We have=20 a tool that can monitor the alert log when it has an agent which is = local to the=20 instance, and will in fact alert on any new entries. If the tool does = not have a=20 local agent though, this function becomes invalid.
 
We can = however set=20 up a User Defined Collection to monitor this if we can return some value = with=20 SQL. Does Oracle store anywhere that it has written to the file? If so = what does=20 it store, and how can I query the database?
 
All = help=20 appreciated..
 
Mark Leith
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
=
Cool Tools UK = Ltd
+44 1905 330 = 281
mark@cool-tools.co.uk