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.