[rrd-users] Re: Need Ping Utility / Oracle Question

Patrick Bartkus patrckb at hotmail.com
Mon Sep 17 16:28:12 MEST 2001

Here's my perl script:
---CUT HERE ---
#       t n s p i n g
#       This program will output two values
#               tnsping time to oracle-db-instance instance on 
#               average ping time to oracle-db-server
#OK (150 msec)

my ($ICMPping);
my ($TNSping);

($ICMPping) = `/usr/local/bin/perl /usr/local/bin/mrtg-ping-probe -p avg/avg 
oracle-db-server |tail -1` ;

($TNSping) = `ORACLE_HOME=/files0/oracle/app/oracle/product/7.3.4;export 
oracle-db-instance | tail -1` ;
($TNSping) = $TNSping =~ /OK \((\d+) msec\)/;
print $ICMPping;
print "$TNSping\n" ;

---CUT HERE ---

It shows a cool graph of network latency vs data base latency.

Patrick Bartkus, SCE, CCNP, CCDA Certified	Sr. Network Support Analyst
Washington Mutual Home Loans, Inc (Formerly Fleet Mortgage)Columbia, SC
If truth was not absolute, how could there be justice?

>From: Paul Wickman <paulw at explosive.net>
>To: Wayne Huang <whuang at osiriscomm.com>
>CC: "Schroeder, Dennis" <Dennis.Schroeder at sanmina.com>, 
>rrd-users at list.ee.ethz.ch
>Subject: [rrd-users] Re: Need Ping Utility / Oracle Question
>Date: Mon, 10 Sep 2001 14:40:02 -0700 (PDT)
>I'm using a wrapper around the Oracle utility 'tnsping' utility.  While
>this reports database connect time, it doesn't report any timing for a
>specific transation.

Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

Unsubscribe mailto:rrd-users-request at list.ee.ethz.ch?subject=unsubscribe
Help        mailto:rrd-users-request at list.ee.ethz.ch?subject=help
Archive     http://www.ee.ethz.ch/~slist/rrd-users
WebAdmin    http://www.ee.ethz.ch/~slist/lsg2.cgi

More information about the rrd-users mailing list