Path: news.cambrium.nl!textnews.cambrium.nl!feeder2.cambriumusenet.nl!feeder3.cambriumusenet.nl!feed.tweaknews.nl!193.201.147.78.MISMATCH!feeder.news-service.com!feeder.erje.net!feeder.eternal-september.org!eternal-september.org!not-for-mail From: Mladen Gogala Newsgroups: comp.databases.oracle.server Subject: Re: Small TNS packages Date: Thu, 19 Nov 2009 19:02:13 +0000 (UTC) Organization: A noiseless patient Spider Lines: 23 Message-ID: References: Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit X-Trace: news.eternal-september.org U2FsdGVkX1+6hIgvPiDAvLMSyx6RBYYak95g0G03cshV5r3PFy8PpCbueZKhSXO9cW8guFvFS8UeLrdHTdJHMrRnuTWm1vg91TQYF0p2kygRqhruuzg1W/pUGBmb9MqBh0J5Jc8pGPw3MlKvQEBDlQ== X-Complaints-To: abuse@eternal-september.org NNTP-Posting-Date: Thu, 19 Nov 2009 19:02:13 +0000 (UTC) X-Auth-Sender: U2FsdGVkX1/cHGmfIRxoEd1DP6dkrTCala5AZIFUbdo= Cancel-Lock: sha1:toZU9GuxLG8ih9Q9ue9C863wWjU= User-Agent: Pan/0.133 (House of Butterflies) Xref: news.cambrium.nl 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