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: [EMAIL PROTECTED]
===================================================
           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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Reply via email to