Slow initial login

[MPippik]

When initially connecting to an 11g database, it often takes 20 to 60 seconds to make the initial connection. Subsequent reconnection to a previously-opened database takes just a few seconds, so it does not seem the burden of returning metadata causes the issue. What could be done to resolve this?
Background:
This issue occurred after upgrading from Oracle 10g to 11g.
It occurs both with 10g and 11g clients.
It is not an issue in SQL*PLUS.
Database version: 11.2.0.2.0
Client version: 11.2.0.1.0
SQLNET.ORA: SQLNET.AUTHENTICATION_SERVICES = (NONE)
SQLNET.ORA has also been tested with other settings (and with the file removed) without benefit.
Local OS: Windows XP sp3
The issue occurs with all connect methods tried: TNSNAMES with failover and load balance, TNSNAMES with SCAN and EZCONNECT.
Setting Oracle Home and OCI library in Preferences seems to be of some help but has not completely resolved it.
Thanks for any suggestions.
M. Pippik

 

[Marco Kalter]

To obtain some more diagnostic information, can you modify the shortcut and add the DebugSQL parameter? For example:

"C:\Program Files\PLSQL Developer\plsqldev.exe" DebugSQL

Reproduce the problem and send me the debug.txt file that is generated in the PL/SQL Developer directory or in the %APPDATA%\PLSQL Developer directory (e.g. C:\Users\\AppData\Roaming\PLSQL Developer).