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

Home -> Community -> Usenet -> c.d.o.server -> SQL*Net Performance on W95

SQL*Net Performance on W95

From: <dpark_at_sctcorp.com>
Date: 1997/11/26
Message-ID: <880561998.6183@dejanews.com>#1/1

Has anyone experienced any performance problems with SQL*Net TCP/IP v2.3.2.1.4 on Windows 95 v4.00.950?

We're running CA-OpenROAD as our development tool, and one of our developers wrote a sample application to generate some performance numbers. Using the same machine that dual-boots Windows 95 and Windows NT, he was getting numbers such as 5 ms to perform an operation on NT40 and 46 ms to perform that same operation on W95.

We put a network sniffer on and it looks as if the same number of packets are being sent back and forth between client and server for both NT40 and W95, but there's an interesting lag with W95 after the server returns the status of the parse operation. This lag is usually about 9ms before the client sends another packet to the server.

Anyone know of any utilties that will allow me to capture calls to the SQL*Net .DLL routines along with timing information? This might help me to isolate the problem to Oracle or to CA OpenROAD. Will SQL Inspector do this?

Any hints, tips, observations, and or suggestions would be much appreciated.

Thanks,

Dave Park
Systems & Computer Technology Corp.
Manufacturing and Distribution Systems Division

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet
Received on Wed Nov 26 1997 - 00:00:00 CST

Original text of this message

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