Alert Log & SQL

From: Mark Leith <mark_at_cool-tools.co.uk>
Date: Tue, 19 Sep 2000 14:59:49 +0100
Message-Id: <10624.117345@fatcity.com>

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_at_cool-tools.co.uk

------=_NextPart_000_0016_01C0224A.422D4040 Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR></HEAD>
<BODY>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D457454913-19092000>Gurus,</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D457454913-19092000></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D457454913-19092000>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? </SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D457454913-19092000></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D457454913-19092000>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.</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D457454913-19092000></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D457454913-19092000>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?</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D457454913-19092000></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D457454913-19092000>All =
help=20
appreciated..</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D457454913-19092000></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN =
class=3D457454913-19092000></SPAN></FONT><FONT=20 color=3D#0080ff size=3D2><EM>Mark Leith</EM></FONT></DIV>
<DIV><FONT color=3D#ff0000 face=3DArial =
size=3D2>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D</FONT></DIV>=

<DIV><FONT color=3D#0080ff size=3D2><STRONG>Cool Tools UK =
Ltd</STRONG></FONT></DIV>
<DIV><FONT color=3D#0080ff face=3DArial size=3D2>+44 1905 330 =
281</FONT></DIV>
<DIV><FONT face=3DArial size=3D2><A=20

href=3D"mailto:mark_at_cool-tools.co.uk">mark_at_cool-tools.co.uk</A></FONT></D= IV> Received on Tue Sep 19 2000 - 08:59:49 CDT