Re: SQL*Net version 2 connections are slow.

SQL*Netters:

I absolutely agree that the named server lookups are dogs from SQL*Net. Why is beyond me. I went from around 13 seconds to 3-4 seconds when I changed to IP addresses. I really can't understand what process accounts for the extra 9 to 10 seconds. A "ping" from my Windows workstation works pretty much equally fast regardless of whether I'm using the server name or the server IP address.

Any other ideas on speading up connections are greatly appreciated. Another area to look at is the parameters in the SQLNET.ORA file.

Try AUTOMATIC_IPC = OFF and TRACE_LEVEL_CLIENT = OFF. Client-level tracing may not be needed.

Rick Ellison
(Ya...I'm the DBA. Sorry...you'll have to call Customer Support...)

In article <3vtdsa$aje_at_sol.aec.ca>, SteveRecsky_at_aec.ca (Steve Recsky) wrote:
>"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 *
>
>
Received on Wed Aug 09 1995 - 00:00:00 CEST