Oracle-L: RE: SLA Trigger/Procedure

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Tue, 03 Dec 2002 11:49:17 -0800
Message-ID: <F001.0051136C.20021203114917@fatcity.com>

Mark - Well, speaking for myself, I appreciate your openness in pointing out the major issues one would have to deal with if they were going to write their own.

Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Tuesday, December 03, 2002 10:34 AM To: Multiple recipients of list ORACLE-L

Dang, I just new that would cause a stir!

Mark <Running away now> Leith

-----Original Message-----
Rajendra
Sent: 03 December 2002 14:32
To: Multiple recipients of list ORACLE-L

Go buy a tool? Here is an idea instead ...

Write a small Perl (pick your favorite language here) script that looks at
/etc/oratab followed by a check to see if each of the instances listed in
/etc/oratab is up on the side where it is checking. It then log in as a
schema (we call it) called heartbeat, insert a row into a table with sysdate. Wait 3 seconds, retrieve the row and checks the time difference. If it is more than 5 seconds, you have a potential delay somewhere and have it alert appropriate people. (If it is night, page your VP with "This is your heartbeat calling ... we have a problem" ...)

Life is great with "cron" ...
HTH
Raj

Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

QOTD: Any clod can have facts, but having an opinion is an art!

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.COM

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).

Received on Tue Dec 03 2002 - 13:49:17 CST