Re: SQL Plus Connection Performance

Jacob Steen Due (jcd_at_ramboll.dk) wrote:

> > bkane_at_clark.net (Brian Kane) wrote:
> >
> > >We are having a problem with the connection performance of SQLPlus
> > >Version 3.2 running on Win95. When we try to connect to an HP Unix
> > >server running Oracle Workgroup 7.1.6.2.0 with SQL Plus 3.2, there is
> > >a 15-20 second delay before we are connected. The same operation
> > >under SQL Plus 3.1 completes in 3-4 seconds. Has anyone else
> > >experienced the same problem? Any insight would be appreciated.

We're using Oracle 7.2.something running on a Novell 4.10 Server and experiencing the same problems. Server performance shouldn't be a problem (Pentium 100 with 140 MB of RAM, and lots of HD-space). Clients are using Windows for Workgroups 3.11

Connections via ODBC or SQLPlus take about 20 seconds. A comment from an Oracle employee on the problem: connects to NT-Servers take about 10 seconds, connects to Novell-Servers about 20 seconds. That's absolutely normal. I honestly can't believe in this.

The server is running SQL*Net V2.1.4, since - according to Oracle - V2.2 has a bug.

> Try writing the TCP/IP address of the server directly in the
> TNSNAMES.ora
> file - that did the trick for me.

Since we're using Novell TCP/IP won't do the trick. Any hints for speeding up the process under Windows 3.1?

Any hints are appreciated.

Thanks in advance.

-Jochen

-- 
Jochen Erwied     |  Internet: mack_at_joker.e.ruhr.de
Knuefen 61        |           Voice: +49-208-995518
D-45475 Muelheim  |    ISDN/V34/FAX: +49-208-995519