Message-Id: <10625.117437@fatcity.com> From: VIVEK_SHARMA Date: Wed, 20 Sep 2000 18:28:58 +0530 Subject: RE: Alert Log & SQL > -----Original Message----- > From: Mark Leith [SMTP:mark@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@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" > > 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@cool-tools.co.uk > > > > > > > > > > -- > > Author: Ruth Gramolini > > INET: rgramolini@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@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@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@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@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@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@fatcity.com (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L