Code assistant is slow

[pavel_j]

Hello,
I'm using using 8.0.4.1514 on Win7/64bit
on my old PC it was working without problem
after moving to new PC with more memory/cpu/etc, with the same OS (win7/64bit) I began to have a problem with code assistant. OS was reinstalled, config for PLSQLdev was taken from the old PC.

writting this SQL:

select * from buffer_e e where e.

after "." it takes about 5 seconds to show columns. It's unusable. The similar times for the others table (with less columns).

With trial version 9.0.6 it's OK.

I have logs from Process Monitor (sysinternals) from both versions 8.0.4 vs 9.0.6
I have also logs from PLSQL developer with parameter DebugSQL from both versions, but comparing I couldn't find any problem.

Homes
odac11 (C:\Program Files (x86)\Oracle\Oracle Instant Client\)
OraClient11g_home1 (c:\oracle\client32\product\11.2.0\client_1)

DLLs
C:\Program Files (x86)\Oracle\Oracle Instant Client\oci.dll

TNS File
C:\Program Files (x86)\Oracle\Oracle Instant Client\Network\Admin\tnsnames.ora

Using
Home: odac11
DLL: C:\Program Files (x86)\Oracle\Oracle Instant Client\oci.dll
OCI: version 11.1
Oracle Database 10g Release 10.2.0.5.0

I was also trying to change odac11 to OraClient11g_home1 but it's the same.

I don't know what is wrong?

Pavel Jurzykowski

 

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

 

[pavel_j]

The files + support info screen from plsql dev was send by email.
Please check.
Thank you.