Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Alert Log & SQL

Re: Alert Log & SQL

From: Anjan Thakuria <Anjan.Thakuria_at_sabre.com>
Date: Wed, 20 Sep 2000 17:00:15 -0500
Message-Id: <10625.117509@fatcity.com>


This is a multi-part message in MIME format.
--------------126ECE8AA59749A2D5EB677D

Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit

Mark,

Hope this helps haven't tried it myself. But found it on the net somewhere.

Anjan

--------------126ECE8AA59749A2D5EB677D

Content-Type: application/x-unknown-content-type-sql_auto_file;  name="alerts.sql"
Content-Transfer-Encoding: base64
Content-Disposition: inline;
 filename="alerts.sql"

cmVtICoqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioq KioqKioqKioqKioqKioqKioqKg0NCnJlbSANDQpyZW0gYWxlcnRzLnNxbA0NCnJlbSANDQpy ZW0gUHVycG9zZTogICAgIFNob3cgZXJyb3JzIGluIGFsZXJ0LmxvZyBmcm9tIHRoZSBsYXN0 IG4gaG91cnMuDQ0KcmVtICAgICAgICAgICAgICBJdCB3b3JrcyBmb3IgYm90aCBVTklYIGFu ZCBOVCBkYXRhYmFzZXMuDQ0KcmVtIA0NCnJlbSBVc2FnZTogICAgICAgQGFsZXJ0cyAyDQ0K cmVtDQ0KcmVtIFJlcXVpcmVkOiAgICAqIHV0bF9maWxlX2RpciBtdXN0IGNvbnRhaW4gYmFj a2dyb3VuZF9kdW1wX2Rlc3QNDQpyZW0gICAgICAgICAgICAgICogYmFja2dyb3VuZF9kdW1w X2Rlc3QgcGFyYW1ldGVyIG11c3QgYmUgYSBjb21wbGV0ZSBkaXJlY3RvcnkNDQpyZW0gICAg ICAgICAgICAgICAgbmFtZSwgaW4gc3RlYWQgb2YgaGF2aW5nIHRoZSBmb3JtICc/L3JkYm1z L2xvZycgb3INDQpyZW0gICAgICAgICAgICAgICAgJyVSREJNUzczJScgZXRjLg0NCnJlbSAN DQpyZW0gQXV0ZXVyOiAgICAgIEJlcm5hcmQgdmFuIEFhbHN0DQ0KcmVtIERhdHVtOiAgICAg ICAxMiBhdWd1c3R1cyAxOTk5DQ0KcmVtDQ0KcmVtICoqKioqKioqKioqKioqKioqKioqKioq KioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKg0NCg0NCnNl dCBzZXJ2ZXJvdXQgb24NDQpzZXQgZmVlZGJhY2sgb2ZmDQ0KZXhlYyBkYm1zX291dHB1dC5l bmFibGUoIDEwMDAwMDApDQ0KREVDTEFSRQ0NCiAgIHZfc2lkIHYkZGF0YWJhc2UubmFtZSVU WVBFOyAvKiBuYWFtIGRhdGFiYXNlICovDQ0KICAgdl9iZHVtcGRlc3QgdiRwYXJhbWV0ZXIu dmFsdWUlVFlQRTsgLyogZGlyZWN0b3J5IHZhbiBhbGVydC5sb2cgKi8NDQogICB2X2NvdW50 IE5VTUJFUjsNDQogICB2X2FsZXJ0bmFtZSBWQVJDSEFSMiggMTkpOyAvKiBmaWxlIG5hYW0g dmFuIGFsZXJ0LmxvZyAqLw0NCiAgIHZfZmlsZV9oYW5kbGUgdXRsX2ZpbGUuZmlsZV90eXBl OyAvKiBoYW5kbGUgbmFhciBhbGVydC5sb2cgKi8NDQogICB2X2VvZiBCT09MRUFOIDo9IEZB TFNFOw0NCiAgIHZfdGV4dCBWQVJDSEFSMiggMjAwMCk7DQ0KICAgdl9kYXRlX3RyeSBEQVRF OyAvKiBIdWxwIHZhci4gdm9vciBkYXR1bSByZWdlbCBpbiBkZSBhbGVydC5sb2cgKi8NDQog ICB2X2RhdGUgREFURTsgLyogQmV3YWFydCBkZSBkYXR1bSByZWdlbCBpbiBkZSBhbGVydC5s b2cgKi8NDQogICB2X2RhdGVfaXNfbmV3IEJPT0xFQU47IC8qIERhdHVtIGthbiBnZXRvb25k IHdvcmRlbiAqLw0NCiAgIHZfaW50ZXJlc3RpbmcgQk9PTEVBTiA6PSBGQUxTRTsgLyogVmFu YWYgaGllciBpcyBoZXQgaW50ZXJlc3NhbnQgKi8NDQogICBjX2FhbnRhbF91cmVuIE5VTUJF UiA6PSAmMTsgLyogQWFudGFsIHVyZW4gdGVydWcgaW4gZGUgdGlqZCB2YW5hZg0NCiAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICB3YW5uZWVyIGFsZXJ0cyBnZXRvb25kIG1v ZXRlbiB3b3JkZW4gKi8NDQogICBGVU5DVElPTiBmaWxlX2RvZXNfZXhpc3QNDQogICAoIGxv Y2F0aW9uX2luIElOIFZBUkNIQVIyDQ0KICAgLCBmaWxlbmFtZV9pbiBJTiBWQVJDSEFSMg0N CiAgICkgUkVUVVJOIEJPT0xFQU4gQVMNDQogICAgICB2X2ZpbGVfaGFuZGxlIHV0bF9maWxl LmZpbGVfdHlwZTsNDQogICBCRUdJTg0NCiAgICAgIHZfZmlsZV9oYW5kbGUgOj0gdXRsX2Zp bGUuZm9wZW4NDQogICAgICAgICAgICAgICAgICAgICAgICggbG9jYXRpb24gPT4gbG9jYXRp b25faW4NDQogICAgICAgICAgICAgICAgICAgICAgICwgZmlsZW5hbWUgPT4gZmlsZW5hbWVf aW4NDQogICAgICAgICAgICAgICAgICAgICAgICwgb3Blbl9tb2RlID0+ICdSJw0NCiAgICAg ICAgICAgICAgICAgICAgICAgKTsNDQogICAgICB1dGxfZmlsZS5mY2xvc2UoIGZpbGUgPT4g dl9maWxlX2hhbmRsZSk7DQ0KICAgICAgUkVUVVJOIFRSVUU7DQ0KICAgRVhDRVBUSU9ODQ0K ICAgICAgV0hFTiBPVEhFUlMgVEhFTg0NCiAgICAgICAgIFJFVFVSTiBGQUxTRTsNDQogICBF TkQgZmlsZV9kb2VzX2V4aXN0Ow0NCkJFR0lODQ0KICAgU0VMRUNUIG5hbWUNDQogICBJTlRP IHZfc2lkDQ0KICAgRlJPTSB2JGRhdGFiYXNlDQ0KICAgOw0NCiAgIFNFTEVDVCB2YWx1ZQ0N CiAgIElOVE8gdl9iZHVtcGRlc3QNDQogICBGUk9NIHYkcGFyYW1ldGVyDQ0KICAgV0hFUkUg bmFtZSA9ICdiYWNrZ3JvdW5kX2R1bXBfZGVzdCcNDQogICA7DQ0KICAgU0VMRUNUIENPVU5U KCopDQ0KICAgSU5UTyB2X2NvdW50DQ0KICAgRlJPTSB2JHZlcnNpb24NDQogICBXSEVSRSBi YW5uZXIgTElLRSAnJVdpbmRvd3MlJw0NCiAgIDsNDQogICBJRiB2X2NvdW50ID0gMCBUSEVO DQ0KICAgICAgLyogSGV0IGlzIGdlZW4gV2luZG93cyBtYWNoaW5lLg0NCiAgICAgIHx8IERl IG5hYW0gdmFuIGRlIGFsZXJ0LmxvZyB3b3JkdCBkYW4NDQogICAgICB8fCBhbGVydF9TSUQu bG9nLCBzb21zIGVjaHRlciBpcyBoZXQNDQogICAgICB8fCBhbGVydF9zaWQubG9nLg0NCiAg ICAgICovDQ0KICAgICAgSUYgZmlsZV9kb2VzX2V4aXN0DQ0KICAgICAgKCBsb2NhdGlvbl9p biA9PiB2X2JkdW1wZGVzdA0NCiAgICAgICwgZmlsZW5hbWVfaW4gPT4gJ2FsZXJ0XycgfHwg dl9zaWQgfHwgJy5sb2cnDQ0KICAgICAgKQ0NCiAgICAgIFRIRU4NDQogICAgICAgICB2X2Fs ZXJ0bmFtZSA6PSAnYWxlcnRfJyB8fCB2X3NpZCB8fCAnLmxvZyc7DQ0KICAgICAgRUxTRQ0N CiAgICAgICAgIHZfYWxlcnRuYW1lIDo9ICdhbGVydF8nIHx8IExPV0VSKCB2X3NpZCkgfHwg Jy5sb2cnOw0NCiAgICAgIEVORCBJRjsNDQogICBFTFNFDQ0KICAgICAgLyogSGV0IGlzIHdl bCBlZW4gV2luZG93cyBtYWNoaW5lICovDQ0KICAgICAgdl9hbGVydG5hbWUgOj0gdl9zaWQg fHwgJ0FMUlQuTE9HJzsNDQogICBFTkQgSUY7DQ0KICAgQkVHSU4NDQogICAgICB2X2ZpbGVf aGFuZGxlIDo9IHV0bF9maWxlLmZvcGVuDQ0KICAgICAgICAgICAgICAgICAgICAgICAoIGxv Y2F0aW9uID0+IHZfYmR1bXBkZXN0DQ0KICAgICAgICAgICAgICAgICAgICAgICAsIGZpbGVu YW1lID0+IHZfYWxlcnRuYW1lDQ0KICAgICAgICAgICAgICAgICAgICAgICAsIG9wZW5fbW9k ZSA9PiAnUicNDQogICAgICAgICAgICAgICAgICAgICAgICk7DQ0KICAgRVhDRVBUSU9ODQ0K ICAgICAgV0hFTiB1dGxfZmlsZS5pbnZhbGlkX21vZGUgVEhFTg0NCiAgICAgICAgIFJBSVNF X0FQUExJQ0FUSU9OX0VSUk9SDQ0KICAgICAgICAgKCAtMjAwMDEsICd0aGUgb3Blbl9tb2Rl IHN0cmluZyB3YXMgaW52YWxpZCcpOw0NCiAgIEVORDsNDQogICBXSElMRSBOT1Qgdl9lb2YN DQogICBMT09QDQ0KICAgICAgQkVHSU4NDQogICAgICAgICB1dGxfZmlsZS5nZXRfbGluZQ0N CiAgICAgICAgICggZmlsZSA9PiB2X2ZpbGVfaGFuZGxlDQ0KICAgICAgICAgLCBidWZmZXIg PT4gdl90ZXh0DQ0KICAgICAgICAgKTsNDQogICAgICBFWENFUFRJT04NDQogICAgICAgICBX SEVOIE5PX0RBVEFfRk9VTkQgVEhFTg0NCiAgICAgICAgICAgIHZfZW9mIDo9IFRSVUU7DQ0K ICAgICAgICAgV0hFTiB2YWx1ZV9lcnJvciBUSEVODQ0KICAgICAgICAgICAgdXRsX2ZpbGUu ZmNsb3NlX2FsbDsNDQogICAgICAgICAgICBSQUlTRV9BUFBMSUNBVElPTl9FUlJPUg0NCiAg ICAgICAgICAgICggLTIwMDAxLCAnbGluZSB0b28gbG9uZyB0byBzdG9yZSBpbiBidWZmZXIn KTsNDQogICAgICAgICBXSEVOIHV0bF9maWxlLmludmFsaWRfb3BlcmF0aW9uIFRIRU4NDQog ICAgICAgICAgICB1dGxfZmlsZS5mY2xvc2VfYWxsOw0NCiAgICAgICAgICAgIFJBSVNFX0FQ UExJQ0FUSU9OX0VSUk9SDQ0KICAgICAgICAgICAgKCAtMjAwMDEsICdmaWxlIGlzIG5vdCBv cGVuIGZvciByZWFkaW5nJyk7DQ0KICAgICAgICAgV0hFTiB1dGxfZmlsZS5yZWFkX2Vycm9y IFRIRU4NDQogICAgICAgICAgICB1dGxfZmlsZS5mY2xvc2VfYWxsOw0NCiAgICAgICAgICAg IFJBSVNFX0FQUExJQ0FUSU9OX0VSUk9SDQ0KICAgICAgICAgICAgKCAtMjAwMDEsICdPUyBl cnJvciBvY2N1cnJlZCBkdXJpbmcgcmVhZCcpOw0NCiAgICAgIEVORDsNDQogICAgICBJRiB2 X2ludGVyZXN0aW5nIFRIRU4NDQogICAgICAgICBJRiBTVUJTVFIoIHZfdGV4dCwgNCwgMSkg PSAnLScgLyogJ09SQS0uLi4sIFBMUy0uLi4sIGV0Yy4gKi8NDQogICAgICAgICBUSEVODQ0K ICAgICAgICAgICAgSUYgdl9kYXRlX2lzX25ldyBUSEVODQ0KICAgICAgICAgICAgICAgZGJt c19vdXRwdXQucHV0X2xpbmUoIENIUiggMTApKTsNDQogICAgICAgICAgICAgICBkYm1zX291 dHB1dC5wdXRfbGluZQ0NCiAgICAgICAgICAgICAgICggSU5JVENBUCggVE9fQ0hBUiggdl9k YXRlLCAnRFkgTU9OIEREIEhIMjQ6TUk6U1MgWVlZWScpKSk7DQ0KICAgICAgICAgICAgRU5E IElGOw0NCiAgICAgICAgICAgIHZfZGF0ZV9pc19uZXcgOj0gRkFMU0U7DQ0KICAgICAgICAg ICAgZGJtc19vdXRwdXQucHV0X2xpbmUoIFNVQlNUUiggdl90ZXh0LCAxLCA4MCkpOw0NCiAg ICAgICAgIEVORCBJRjsNDQogICAgICBFTkQgSUY7DQ0KICAgICAgQkVHSU4NDQogICAgICAg ICB2X2RhdGVfdHJ5IDo9IFRPX0RBVEUoIHZfdGV4dCwgJ0RZIE1PTiBERCBISDI0Ok1JOlNT IFlZWVknKTsNDQogICAgICAgICBJRiB2X2RhdGUgIT0gdl9kYXRlX3RyeSBPUiB2X2RhdGUg SVMgTlVMTA0NCiAgICAgICAgIFRIRU4NDQogICAgICAgICAgICB2X2RhdGUgOj0gdl9kYXRl X3RyeTsNDQogICAgICAgICAgICB2X2RhdGVfaXNfbmV3IDo9IFRSVUU7DQ0KICAgICAgICAg ICAgSUYgdl9kYXRlID4gU1lTREFURSAtICggY19hYW50YWxfdXJlbiAvIDI0KSBUSEVODQ0K ICAgICAgICAgICAgICAgdl9pbnRlcmVzdGluZyA6PSBUUlVFOw0NCiAgICAgICAgICAgIEVO RCBJRjsNDQogICAgICAgICBFTFNFDQ0KICAgICAgICAgICAgdl9kYXRlX2lzX25ldyA6PSBG QUxTRTsNDQogICAgICAgICBFTkQgSUY7DQ0KICAgICAgRVhDRVBUSU9ODQ0KICAgICAgICAg V0hFTiBPVEhFUlMgVEhFTg0NCiAgICAgICAgICAgIE5VTEw7IC8qIERlIHJlZ2VsIGJldmF0 dGUgZ2VlbiBkYXR1bS4gV2UgZ2FhbiBnZXdvb24gZG9vci4gKi8NDQogICAgICBFTkQ7DQ0K ICAgRU5EIExPT1A7DQ0KICAgdXRsX2ZpbGUuZmNsb3NlKCBmaWxlID0+IHZfZmlsZV9oYW5k bGUpOw0NCkVYQ0VQVElPTg0NCiAgIFdIRU4gdXRsX2ZpbGUuaW52YWxpZF9wYXRoIFRIRU4N DQogICAgICBkYm1zX291dHB1dC5wdXRfbGluZQ0NCiAgICAgICggJ2FsZXJ0cy5zcWw6IHV0 bF9maWxlLmludmFsaWRfcGF0aCBlbmNvdW50ZXJlZC4gJyB8fA0NCiAgICAgICAgJ0NoZWNr IHV0bF9maWxlX2Rpci4nDQ0KICAgICAgKTsNDQogICBXSEVOIHV0bF9maWxlLmludmFsaWRf b3BlcmF0aW9uIFRIRU4NDQogICAgICBJRiB2X2JkdW1wZGVzdCBMSUtFICclJCUnDQ0KICAg ICAgT1Igdl9iZHVtcGRlc3QgTElLRSAnJT8lJw0NCiAgICAgIE9SIHZfYmR1bXBkZXN0IExJ S0UgJyVcJSUnIEVTQ0FQRSAnXCcNDQogICAgICBUSEVODQ0KICAgICAgICAgZGJtc19vdXRw dXQucHV0X2xpbmUNDQogICAgICAgICAoICdhbGVydHMuc3FsOiBVbmFibGUgdG8gcmVhZCBh bGVydC5sb2cgYmVjYXVzZSAnIHx8DQ0KICAgICAgICAgICAnb2YgYmFja2dyb3VuZF9kdW1w X2Rlc3QgcGFyYW1ldGVyICcgfHwgDQ0KICAgICAgICAgICB2X2JkdW1wZGVzdCB8fCAnLicN DQogICAgICAgICApOw0NCiAgICAgIEVMU0UNDQogICAgICAgICBkYm1zX291dHB1dC5wdXRf bGluZQ0NCiAgICAgICAgICggJ2FsZXJ0cy5zcWw6IHV0bF9maWxlLmludmFsaWRfb3BlcmF0 aW9uIGVuY291bnRlcmVkLicpOw0NCiAgICAgIEVORCBJRjsNDQpFTkQ7DQ0KLw0NCg0NCnNl Received on Wed Sep 20 2000 - 17:00:15 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US