0 Replies Latest reply: Jan 9, 2013 4:53 AM by 983745 RSS

    Database login takes too long after upgrade from 10g to 11g

      Hello, i have a Win 2003 server Oracle installation and when i use the command line sqlplus username/password@database the login takes about 12 seconds. If i exit and then login again (within about 5 seconds) i can connect in just 1 second. If i exit and then try again in 20 seconds it goes back to taking 12 seconds to connect.
      The spec of the server is better than the Oracle 11g requirements. I have turned off any firewall and virus checkers that maybe causing this and also checked the CPU activity when the login is being processed but there is still 60% of CPU power left.
      Has anyone come across this sort of thing before or could someone offer any advise please?