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

[Wayne Huang]

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


-- 
Wayne Huang <whuang at osiriscomm.com>
Osiris Communications, Inc.
http://www.osiriscomm.com
(877) 219-3708 (Office)
(978) 383-6390 (Fax)


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