Re: ORACLE ON A WAN

andy wrote:
>
> 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.
>
> Thanks in advance.
>
> Andy

I don't have actual benchmarks, but Net*8 most certainly has better performance over WAN and VPN connections than SQL*Net 2.3.x. If you open a TAR with Oracle Worldwide Support, the first thing that they are going to tell you is to upgrade to a supported product - unless you have coughed up the 30% lifetime fee for Extended Maintenance Support.

8.1.6 is off support as of 31-SEP-2001 - upgrade to 8.1.7 asap.

If all else fails, throw lots of cash (and GHz of CPU, GB of RAM) at a Citrix MetaFrame Server farm.

Have you investigated traffic shaping - or setting the TOS bits (priority) on the packets on the routers and firewall(s)?

As far as lots of small packets - that's sqlnet and your front end program.
Upgrade to 8.1.7 and use bulk collect features. If you can use a larger array size - and return a table, rather than a row - your packets will be fewer and larger.

Paul Received on Sat Jun 16 2001 - 01:21:16 CDT