ORACLE ON A WAN

From: andy <news_at_info-line.it>
Date: Fri, 15 Jun 2001 16:23:44 GMT
Message-ID: <3b2a2eec.32080959@news.cis.dfn.de>

We are using Oracle database installed on a NT machine, the version is 7.3.4.
The clients are connected to the db Oracle by a large band connection (about 1 Mb). They use TCP-IP protocol over the network. Programs are builted in Delphi 2 and need BDE (Borland Database Engine) version 5.1.1. In the BDE interface the parameter NET PROTOCOL is set to TNS.

We have analyzed traffic networks on the WAN and there is a lot of small packets (request of client and respond of the server). Performance of Delphi programs are not so good. Performance in a LAN are very good, obviously.

The question is: in Oracle can i control network packets size? What about SDU, listener Queue size and TCP.NODELAY?

Thanks in advance.

Andy Received on Fri Jun 15 2001 - 11:23:44 CDT