Oracle-L: RE: Database tracking

From: Jamadagni, Rajendra <Rajendra.Jamadagni_at_espn.com>
Date: Wed, 15 Jan 2003 12:14:50 -0800
Message-ID: <F001.00530992.20030115121450@fatcity.com>

Tom,

This is what we do ...
We have a schema called "heartbeat" ... owns a table called rhythm (one column time_stamp data type date);

Using a perl program, we log on to instance, insert a row in the table with value sysdate.
Use dbms_lock.sleep to sleep for 3 seconds.
select sysdate-time_stamp from rhythm;
rollback;
exit from the program.

If the difference at stage 3 is > 5 seconds, the web-page goes red, if it is
> 6 seconds the alarm goes off.

Works fine ... we have this set-up on all our RAC instances ... The query is run from a monitoring server that connects to the database on public network (as everyone else) and also has 2 private networks ... if public network goes away.

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!

-----Original Message-----
Sent: Wednesday, January 15, 2003 1:59 PM To: Multiple recipients of list ORACLE-L

I guess I would also like to test out the network response time. If I run the same SQL from one UNIX box to the production databases at other sites (via sqlnet), I can record total run time and sql statement run time (I assume the difference would be network response time?). If I keep this information forever then I will know if the databases are slowing down or speeding up. I could also determine if particular boxes are speeding up or slowing down.

The question is, what would be a good SQL statement to test? Is SQL> select count(*) from dba_tables;
as good as another?

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jamadagni, Rajendra
  INET: Rajendra.Jamadagni_at_espn.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).



text/plain attachment: ESPN_Disclaimer.txt

Received on Wed Jan 15 2003 - 14:14:50 CST