Re: Tracing time spent on the network

From: Palooka <nobody_at_nowhere.com>
Date: Wed, 25 Feb 2009 00:57:01 +0000
Message-ID: <uH0pl.20853$de5.15536_at_newsfe10.ams2>

Chris wrote:
> 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 ?
>

He ought to. It's pretty basic tracing.

Palooka Received on Tue Feb 24 2009 - 18:57:01 CST