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

res0kdc5 wrote:
>
> 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.

See if there are any AFTER LOGON triggers defined - they might be doing some work...

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."