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 <[EMAIL PROTECTED]> >To: Wayne Huang <[EMAIL PROTECTED]> >CC: "Schroeder, Dennis" <[EMAIL PROTECTED]>, >[email protected] >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:[EMAIL PROTECTED] Help mailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-users WebAdmin http://www.ee.ethz.ch/~slist/lsg2.cgi
