RE: SLA Trigger/Procedure

For reasons too long to go in to, "go buy a tool" is not a good option for my purposes. Besides, why buy what I can build? These are exactly the sort of challenges that make my job worth coming to.

Thanks,
Ethan

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

Yup, got that covered :)

If I may add another point. When dealing with SLA's, you not only have to
"show" that the database has been servicing users that are connected
(showing database uptime), but also that users can also *connect* to the database as well (the listener is servicing requests).

If you were to go about this with a trigger/procedure that inserts in to a table, then this doesn't show that the database was available to
"everybody".

Typically what we do with monitoring tools is a "connect on ping", so when we are checking availability of a database we do a full connect, then
"select 'PING' from dual;". If there are any errors along the way we search
for the error code, and deal with the appropriate alerts (TNS = Listener
"problem", ORA = Database "problem").

Of course, the problem with doing it this way, is that you are going to have to write platform dependant scripts (batches for NT, shell type scripts for Unix), and not have a "one for all" with a database based solution.

Go buy a tool. Let it write to a table/file, alert you AND make the coffee for when you get there! ;)

Mark

 Mark Leith             | T: +44 (0)1905 330 281
 Sales & Marketing      | F: +44 (0)870 127 5283
 Cool Tools UK Ltd      | E: mark_at_cool-tools.co.uk
===================================================
           http://www.cool-tools.co.uk
       Maximising throughput & performance

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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Post, Ethan
  INET: Ethan.Post_at_ps.net

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).