Re: Oracle application from remote client, very slow

xtanto_at_hotmail.com (Krist) wrote in message news:<cb48a3b.0210101849.2b470622_at_posting.google.com>...
> Hi All,
>
> We have Application package using Oracle 8i SE (on Win2K) as backend.
> The application is accessed from both local client (LAN) and
> remote client ( 64Kbps digital leased line ).
>
> These two type of clients get very difference performance.
> e.g : for data entry application
> Local client needs 2 seconds to save to backend
> Remote client needs 60 seconds to save to backend
>
> Apart from that this could be because the application and the database
> is not designed properly,
> Is there any general setting that could be the reason ?
> Or 64Kbps is not enough ? or any other thing that we could do without
> re-designed the application or the database ?
>
> Thanks for any help,
> Krist

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. As you don't provide any specs of your hardware and O/S it is difficult to provide any specific advice. 64k however is likely to qualify as insufficient bandwith. Also, I don't think the database or the application is the cause.

Hth
Sybrand Bakker
Senior Oracle DBA Received on Fri Oct 11 2002 - 04:03:01 CDT