Re: SQL*Net version 2 connections are slow.

"C.J. Jardine" <cj10_at_cam.ac.uk> wrote:

>I have a problem using SQL*Net version 2 to connect clients running
>MS WFWG 3.11 to a server running Solaris 2.4.
 

>Everything works OK, but connection is VERY SLOW. There seems to
>be a 15 second pause during which nothing happens (and the PC is
>entirely locked up). Once connected, performance seems OK>
 

>SQL*Net v2 connections from Unix boxes do not seem to suffer this delay,
>nor do SQL*Net v1 connectins from the PCs.
 

>The software versions invloved are:
 

>Client: SQL*Net version 2.1.4.1.4 with tCP/IP adaper version 2.1.4.1.3A.
> Lan Workplace version 4.12. Windows 3.11.
 

>Server: SQL*Net version 2.1.4.1.0, RDBMS version 7.1.4.1.0
> Solaris 2.4.
 

>I would be very grateful for any hints as to the cause of this delay.
 

>Charles Jardine, University of Cambridge, UK

We were also hit by the slowdown when we went to 2.1.

Try hard coding in your IP addresses in your TNSNAMES.ORA file.

It is a pain if you ever change database locations, but it greatly improves performance by removing the DNS lookup overhead.

Regards,
Steve

• Steve Recsky, Staff DBA * Voice (403) 266-8283 (OFFICE) *
• ALBERTA ENERGY COMPANY LTD. * Fax (403) 290-8283 (OFFICE) *
• 3900, 421 - 7th Avenue S.W. * *
• Calgary, AB, Canada T2P 4K9 * SteveRecsky_at_aec.ca *