Re: Jboss/Oracle/select 1 form dual
- From: Nigel Thomas <nigel.cl.thomas@xxxxxxxxxxxxxx>
- To: Pradeep.Chetal@xxxxxxxxxxxxxx
- Date: Thu, 7 May 2009 23:13:33 +0100
2009/5/7 Pradeep Chetal <Pradeep.Chetal@xxxxxxxxxxxxxx>
>
> 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
Other related posts:
