Re: Jboss/Oracle/select 1 form dual

From: Nigel Thomas <nigel.cl.thomas_at_googlemail.com>
Date: Thu, 7 May 2009 23:13:33 +0100
Message-ID: <53258cd50905071513s726d4cfal86111c677e144503_at_mail.gmail.com>

2009/5/7 Pradeep Chetal <Pradeep.Chetal_at_mformation.com>

>
> Actually I am using dynatrace profiler and it tells me that out of 4000
> calls to Oracle, min time is 4 ms, avg time is 10 msec, and max time is 3780
> msec
>
>
>
> Since avg is so close to min, I am assuming there are very few outliers but
> want to understand why.
>
>

Pradeep

If I understand correctly, dynatrace is tracing this from the point of view of the client. So Jared's point would stand - there is infrastructure (ie network latency) included in the time.

You should monitor from the Oracle point of view and see the stats there to confirm whether the max (database) time goes that high.

Personally, I would shoot anyone who configures a pointless additional select statement to check connectivity; I blogged on it<http://preferisco.blogspot.com/2006/04/is-this-oracle-wtf.html>a couple of years ago and it has come up several times on this list. But that's another matter.

Regards Nigel

--
http://www.freelists.org/webpage/oracle-l

Received on Thu May 07 2009 - 17:13:33 CDT