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:[EMAIL PROTECTED]
Help mailto:[EMAIL PROTECTED]
Archive http://www.ee.ethz.ch/~slist/rrd-users
WebAdmin http://www.ee.ethz.ch/~slist/lsg2.cgi
