Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> sqlplus takes 10 to 15 seconds to connect - Can anyone help
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. Received on Thu Oct 18 2001 - 21:13:49 CDT
![]() |
![]() |