Re: Oracle application from remote client, very slow

From: Krist <xtanto_at_hotmail.com>
Date: 15 Oct 2002 00:07:11 -0700
Message-ID: <cb48a3b.0210142307.5cf529ba@posting.google.com>

Hi Sybrand,

> You might have 2 different M(ax)T(ransmission)U(nit)s, one locally,
> and one remotely. However, as the default SDU of sqlnet is 2048, which
> usually doesn't match any default MTU on network level this seems an
> unlikely cause.
> You need to find out whether you are suffering from packet fragmenting
> on the network level.

What should I do to find out whether I suffer from packet fragmenting ? Is the MTU / SDU setting related to this ?

> As you don't provide any specs of your hardware
> and O/S it is difficult to provide any specific advice.
Server : Win2000 Server, Pentium III 1GHz, RAM 512 MB Client : Windows XP, Pentium IV 1.4GHz, RAM 128 MB Is there anyother specs do you need ?

> 64k however is likely to qualify as insufficient bandwith.
What is the bandwith to be sufficient ?

> Also, I don't think the database or the application is the cause.
Received on Tue Oct 15 2002 - 02:07:11 CDT