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

From: Russ Eberle <russ.eberle_at_born.com>
Date: 1996/10/21
Message-ID: <54egg2$63@news.mr.net>#1/1

Leifur Bjorn Bjornsson <bjornsson_leif_at_tandem.com> wrote:

>Hello folks,

>We are experiencing slow response time when connecting to a database
>through sqlplus or sqldba. It takes upto 5 seconds after the username
>and password have been submitted. On another system, the response is
>instantaneous.

>We are running Oracle 7.1.6 on SGI IRIX 5.3. Any ideas what could be
>causing this slowdown?

>Cheers,
>Leif Bjornsson

If you are using 7.3, there is a bug concening this. There is a trace function that is on by default. The output is in $ORACLE_HOME/otrace. I believe the files are reg*.dat and proc.dat. To shut this off, you need to set an environment variable to FALSE. I don't remember it right off the top of my head, but if you follow up with me via email, I'll let you know.

Russ russ.eberle_at_born.com Received on Mon Oct 21 1996 - 00:00:00 CDT