Re: Tracing time spent on the network
Date: Wed, 25 Feb 2009 00:11:42 GMT
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
> 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