Re: Small TNS packages

From: Mladen Gogala <no_at_email.here.invalid>
Date: Thu, 19 Nov 2009 19:02:13 +0000 (UTC)
Message-ID: <pan.2009.11.19.19.02.12_at_email.here.invalid>

On Thu, 19 Nov 2009 17:06:21 +0000, Troels Arvin wrote:

> Hello,
>
> I'm transferring a sizeable amount of data from an Oracle 11 DBMS over a
> VPN tunnel; the client software is also Oracle 11. Both client and
> server are running Linux. There row widths in the involved tables vary
> somewhat, but BLOBs aren't involved.
>
> When inspecting the data in Wireshark, I see TNS packages with sizes
> between 350 and 450; the TCP window size is 501. I find this to be
> rather small drops of data.
>
> Are TNS packages this small normal?

That depends on the characteristics of your fetch. If you're doing an array fetch, this is unusual. If, on the other hand, you're doing single row operations, that's the normal behavior.

-- 
http://mgogala.byethost5.com

Received on Thu Nov 19 2009 - 13:02:13 CST