Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> SQL*Net Performance
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.chHelvetia Patria Versicherungen
St. Alban-Anlage 26 Tel: ++41(0)61 280 1887 4002 Basel Fax: ++41(0)61 280 2968Received on Mon Sep 14 1998 - 05:55:38 CDT