> -----Original Message-----
> From: Mark Leith [SMTP:mark_at_cool-tools.co.uk]
> Sent: Wednesday, September 20, 2000 4:25 PM
> To: Multiple recipients of list ORACLE-L
> Subject: 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-----
> Sent: 19 September 2000 19:28
> To: mark_at_cool-tools.co.uk
>
>
> 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
> 858-831-2229 San Diego, CA 92131
> I got high on the mountain at the ORACLE of Delphi!!!
>
> --
> 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
Received on Wed Sep 20 2000 - 07:58:58 CDT
