sqlplus login slow

[pascal01]

I have a database on windows 2003 x64bit that is slow at logon.
This is true for sqlplus or any application at logon. Once logged in, it is very fast, no performance problems. This server has 32GIGS of RAM. The SGA is 10GIGS, 20GIGS free. Its very strange, because all other windows and solaris db servers do not have this logon problem. I also set client level tracing in sqlnet.ora, and there is no problem that I can see. When I do a tnsping, it is very fast, almost immediate. I also bypassed the listener(no alias) by logging in dbserver. Same login problem. So I assume its not a listener problem. I am running out of ideas.

[davey23uk]

trace the connection - see where the time is being taken

[pascal01]

Do you mean netstat ? I couldn't find anything significant after I set TRACE_LEVEL_CLIENT=16.

[davey23uk]

no, trace the database connection - just like you would with any slow process

[mahajanakhil198]

dave. Would you please tell how can we trace a connection process? Or you just meant through User Trace files in USER_DUMP_DEST?

[giteshtrivedi]

Hi,

Is there any logon trigger available? Check glogin.sql in server side.

[pascal01]

No logon triggers. Its very strange, it takes 8 seconds to logon to a windows 2003 x64 server (32GIG RAM) and 1 second on a windows 2003 32 bit (8 GIG RAM) server. Same database on different platforms. Maybe an OS config issue ? Why the difference ? Any recommendations.

[davey23uk]

yes - trace the connection, see where the time is being taken