Xref: alice comp.databases.oracle.tools:14202
Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!logbridge.uoregon.edu!newsgate.cuhk.edu.hk!news.cuhk.edu.hk!news.erg.cuhk.edu.hk!iesun44!mhpuk5
From: puk man ho <mhpuk5@ie.cuhk.edu.hk>
Newsgroups: comp.databases.oracle.tools
Subject: Help on tuning oracle server-client communication
Date: Tue, 7 Jul 1998 17:07:04 +0800
Organization: Engineering Faculty CUHK
Lines: 22
Message-ID: <Pine.SOL.3.95.980707165348.25441B-100000@iesun44>
Mime-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
X-Sender: mhpuk5@iesun44

Hi,

   I have a WAN link with high latenacy (around 600ms in a round trip).
When our Oracle client perform queries thougth this WAN link to access the
Oracle server, we found that the speed of retreving the record is very
slow(about 20 min for retreving record in WAN which can be done in 2 min
for same bandwidth LAN).It is not because bandwidth of this link is fully
utilized, but we find that:
	1, server response to the client with large number of small
	   packets to the clients
	2, both ends will not send futher data until the acknowledgment of
	   the pervious packet is received.

   As this link has large delay, acknowledging large number small packets
makes sending data extremely slow. 

Can I force the server to buffer all data in a query and send them in one
piece?

Best Regards
Michael Puk