Re: SQL Plus Connection Performance
Date: 1996/09/27
Message-ID: <52gvra$shs_at_netope.harvard.edu>#1/1
In article <52eqog$jgi_at_wesel.mh.ruhr.de>, mack_at_joker.e.ruhr.de says...
>
>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
I have Oracle 7.1, 7.2, and 7.3 databases running on different Netware and NT
machines. Connections generally take 0.5-2 seconds depending upon the load of
the server. The suggestions of using the ip number (for tcp/ip obviously) is
to remove the overhead of DNS lookup. I'm shocked that an Oracle employee
should tell you that 10-20 seconds is normal!
Received on Fri Sep 27 1996 - 00:00:00 CEST