Help on tuning oracle server-client communication

   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 Received on Tue Jul 07 1998 - 11:07:04 CEST