Re: Slow response time connecting to db from sqlplus or sqldba

From: Dave Clarke <dave_at_keve.demon.co.uk>
Date: 1996/11/03
Message-ID: <847018751.23318.0_at_keve.demon.co.uk>#1/1


ehouzell_at_filnet.fr (ehouzell) wrote:

>I don't have seen the other articles about the problem you
>are talking about but as you are talking about listener.ora and
>tnsnames.ora I think you are using SQL*NET version 2.
 

>We are working with oracle 7.x.x from the beginning (beta versions)
>and the problem of long connect times apeared with SQL*NET version 2.
 

>We tried to solve this problem in turning alias into addresses but
>we did not succeed. Oracle FRANCE have said they know the existence
>of this problem but they don't have any solution. That's the reason
>why we turned SQL*NET 2 into SQL*NET 1 on all our systems.
 

>SQL*NET version 1 is no longer support by ORACLE but this version
>is running so good that we think we don't need support

Unfortunately in 7.3 SQL*Net V1 goes leaving V2 the only option, having spent the previous numerous versions I'm now having to learn that vile syntax Received on Sun Nov 03 1996 - 00:00:00 CET

Original text of this message