Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> sqlplus takes 10 to 15 seconds to connect - Can anyone help

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

From: res0kdc5 <ppoorna_at_verizon.net>
Date: Fri, 19 Oct 2001 02:13:49 GMT
Message-ID: <x%Lz7.375$Qa.89686@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. Received on Thu Oct 18 2001 - 21:13:49 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US