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

[Patrick Bartkus]

Here's my perl script:
---CUT HERE ---
#!/usr/local/bin/perl
#
#       t n s p i n g
#
#       This program will output two values
#               tnsping time to oracle-db-instance instance on 
oracle-db-server
#               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_HOME;/files0/oracle/app/oracle/product/7.3.4/bin/tnsping 
oracle-db-instance | tail -1` ;
($TNSping) = $TNSping =~ /OK \((\d+) msec\)/;
print $ICMPping;
print "$TNSping\n" ;

exit;
---CUT HERE ---

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

Patrick
---
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