Re: Oracle Performance on WAN (with T1 network)

From: Joneveland <joneveland_at_aol.com>
Date: 12 Jul 1998 14:53:24 GMT
Message-ID: <1998071214532400.KAA01144@ladder01.news.aol.com>

>Our application is not written using Oracle dev. tools but is base on an
>Oracle database (on NT) which is installed with the common parameters

If you are using ODBC , you are also running SQL*Net to maintain C/S sessions with the ORACLE instance. This creates a lot of network traffic, and it will get worse with more users. The ORACLE C/S scheme uses a polling listener to maintain sessions with the client. Great for a LAN, heavy traffic on a LAN.

One idea is to develop 3 tier C/S, using an HTML server for the application, and HTTP between the client and the application server. This keeps the SQL*Net connection only between the application server and the database server.

Upgrading the WAN line to T3 could help.

Also, upgrade the clients to fast ethernet. would help. Received on Sun Jul 12 1998 - 09:53:24 CDT