Re: Tracing time spent on the network

From: Chris <user_at_home.com>
Date: Wed, 25 Feb 2009 00:11:42 GMT
Message-ID: <Xns9BBCC342EABDAihavenospecialidtoke_at_127.0.0.1>

johnbhurley_at_sbcglobal.net wrote in news:e1289d81-2581-4828-93c9- b77cb969d2c0_at_x38g2000yqj.googlegroups.com:

> Are you using an application server and/or middleware that does
> connection pooling for the java application or do you get a direct
> connection?
>
> If a direct connection it is easy enough to get a low level oracle
> trace ( 10046 ) and get that put thru a resource profiler to see how
> much time is being spent between calls to the database server. Try
> buying a dba a good coffee and they may be glad to help you do a trace
> like that.

Hey John thanks,
Yes I reproduce the latency using a straight JDBC call I will talk to my DBA :)
So he will understand the 10046 ?

Thanks again :)
Chris Received on Tue Feb 24 2009 - 18:11:42 CST