RE: Alert Log & SQL

Charlie,

Thanks for the response.. I think :)

Fair enough, this can't be done in SQL it seems, but how would I then do it with PL/SQL? You'll have to forgive my coding skills, which are in fact almost nonexistent - Next stage of training I think !!

How about a "trivial" answer to the question ? :->

Regards

Mark

-----Original Message-----
From: Charlie Mengler [mailto:charliem_at_mwh.com] Sent: 19 September 2000 19:28
To: mark_at_cool-tools.co.uk
Subject: Re: Alert Log & SQL

A person whose only tool is a hammer will treat all problems as if they are nails!
Virtually NOTHING is impossible through software if your are willing to throw enough resourses at the problem.

You keep insisting that only SQL be used. AFAIK, SQL has NO way to "branch on condition"; ie IF ... THEN ... and base it subsequent actions on some value.

The solution is "trivial" via PL/SQL.

HTH & YMMV! Mark Leith wrote:
>
> 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-----
> Gramolini
> Sent: 19 September 2000 16:36
> To: Multiple recipients of list ORACLE-L
>
> 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 -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> 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
> > mark_at_cool-tools.co.uk
> >
> >
>
> --
> Author: Ruth Gramolini
> INET: rgramolini_at_tax.state.vt.us
>
> 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: ListGuru_at_fatcity.com (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).
>
> --
> Author: Mark Leith
> INET: mark_at_cool-tools.co.uk
>
> 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: ListGuru_at_fatcity.com (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).

--
Charlie Mengler               Maintenance Warehouse
charliem_at_mwh.com              10641 Scripps Summit Ct