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

[Paul Wickman]

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.

On Mon, 10 Sep 2001, Wayne Huang wrote:

> 
> > Also, has anyone done any monitoring of Oracle Application response time?  I
> > need to figure out how to capture the amount of time a transaction takes
> > (the same one over and over) and record that into an RRD too.
> 
> I'm not sure how to get Oracle's response time to a query (as I'm sure
> there is some way to do that).  But you could just write a program that
> does:
> 
> struct timeval start,end;
> ...
> (void) gettimeofday( &start, (struct timezone *) NULL );
> ... run oracle sql query
> (void) gettimeofday( &end, (struct timezone *) NULL );
> 
> and record the difference between the two times?
> 

---
	There's shadows in life, babe...
					- Jack Horner


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