Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> SQL*Net Performance

SQL*Net Performance

From: Antoine Ehlinger <Antoine.Ehlinger_at_HelvetiaPatria.ch>
Date: Mon, 14 Sep 1998 12:55:38 +0200
Message-ID: <35FCF62A.75B1B5B6@HelvetiaPatria.ch>


Hello

I have got some performance problems with the following configuration:

                                       ¦- - - - - -  - - W A N   - - - -
- - -¦
¦                                                  ¦
Server ---- TKR ---- Router ------ Frame Relay ------ Router -- TKR --- Client
HP-UX 10.20            Cisco           CIR 64 K
Cisco                    NT 4.0
Oracle 7.3.3                                 MTU
1500                                             SQL*Net

Delphi

The MTU is everywhere set to 1500 bytes.

The server sends 2.5 KB of data in 2 packets and than waits on the clients answer
(packet with push-bit set and 17 bytes of data). Thow the delay over the frame
relay
is nearly 220 ms, there are 440 ms lost for every 2.5 K sent over the network!

It seems that SQL*Net makes a sort of flow control, cutting off the efficency of the
TCP/IP
windowing. Although the window size is set to 16 KB, there are never more than
2K being used.

How can I improve the way that SQL*Net works?

--

Antoine Ehlinger                 Antoine.Ehlinger_at_helvetiapatria.ch
Helvetia Patria Versicherungen
Engennering Service - Operating Systems
St. Alban-Anlage 26             Tel:    ++41(0)61 280 1887
4002 Basel                      Fax:    ++41(0)61 280 2968


Received on Mon Sep 14 1998 - 05:55:38 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US