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.
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.