Re: Slow connection

From: Jas <jdhaliwal_at_computerweekly.com>
Date: Thu, 19 Aug 1999 13:14:51 +0100
Message-ID: <935065042.23190.0.nnrp-13.c3ad5001@news.demon.co.uk>

HI wozi

The problem may be related to your SQL-Net set up. Are you routing by Oracle Names Server or TNS Names ?

If you are using Oracle Names Server and the primary server fails , then SQL-Net will wait for a timeout period (as specified in LISTENER.ORA) before attempting to use the secondary names server. This timeout may be the cause of the delay.

wozi wrote in message
<2123F2C07B908823.0AE7C10C64A14413.AB0D14CBC8E88703_at_lp.airnews.net>...
>I am running Oracle 7.3 and Oracle 8 on 2 different NT 4.0 machines.
>
>When I connect from sql*plus, it takes about 30 seconds to establish
>connection. The maximum number of developers logged in to the instances
>at any given time is no more than 5.
>
>Any help on tuning the server side would be appreciated.
>
>Please, copy tyc77_at_hotmail.com
>
>Thanks
>
>
Received on Thu Aug 19 1999 - 07:14:51 CDT