PL/SQl Developer is very slow

[jlt]

Hi,

PL/SQL Developer version: 7.0.3.1123

PL/SQl Developer is very slow to start.

Debug.txt:

08/10/2007 10:09:41 TOracleSession $021AAEB0 Start Session.LogOn as dba@Vendeur
08/10/2007 10:10:05 TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
08/10/2007 10:10:05 TOracleQuery Query End (1 record processed)
Duration = 0
08/10/2007 10:10:05 TOracleSession $021AAEB0 End
Duration = 23,078

Any idea?

Thanks.
JLT.

 

[Marco Kalter]

This may be an Oracle Net configuration issue. Can you send me the sqlnet.ora file from your \Network\Admin directory?

 

[jlt]

File's content:

# C:\ORANT\NET80\ADMIN\SQLNET.ORA Configuration File:C:\orant\net80\admin\sqlnet.ora
# Generated by Oracle Net8 Assistant

NAME.DEFAULT_ZONE = world

NAMES.DEFAULT_DOMAIN = world

NAMES.PREFERRED_SERVERS =
(ADDRESS_LIST =
(ADDRESS=(PROTOCOL=TCP)(HOST=182.219.269.15)(PORT=1575))
)

sqlnet.authentication_services = (NONE)
names.directory_path = (ONAMES, TNSNAMES)
#names.directory_path = (TNSNAMES, HOSTNAME)

SQLNET.EXPIRE_TIME = 0

#SQLNET.ENCRYPTION_SERVER = requested

#SQLNET.ENCRYPTION_CLIENT = requested

 

[Marco Kalter]

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