Re: sqlplus takes 10 to 15 seconds to connect - Can anyone help

"res0kdc5" <ppoorna_at_verizon.net> wrote in news:x%Lz7.375$Qa.89686_at_paloalto-snr1.gtei.net:

> Platform: Sun Solaris
> Database Version: 8.1.7.2
> When I issue the following command to connect to the database using
> "sqlplus", it takes about 10 to 15 seconds to display the SQL> prompt.
>
> $ sqlplus /
>
> It does not matter if I use a different userid. This is not true for
> other 8.1.7.2 databases. It only takes 2 to 3 seconds on other
> databases for sqlplus to connect to the databases. I have verified that
> Oracle tracing is not set, and auditing is also not enabled. There are
> not ".dat" files in $ORACLE_HOME/otrace/admin directory. Even though I
> do not use sqlnet, I have also tried trimming the listener log. I am
> not able to figure out what might be causing the lengthy delay. Any
> help/suggestions is much appreciated. Thanks.
>
>
>

One way to troublshoot this is to start a SQLPLUS session WITHOUT entrting any username/password.
Then from a different window with root access, find the PID of the waiting SQLPLUS process.
$ script /tmp/cature.log
$ truss -p ${PID} # from the SQLPLUS process

Then in the SQLPLUS process enter the username/password

Make note of where in the truss out the hang occurs. Hopefully it will provide the needed insight WRT where the delay is happening.

HTH & YMMV! Received on Fri Oct 19 2001 - 18:54:56 CDT