Code Assistant Performance

[suess]

Hi

We have a pretty large oracle database that use with PL/SQL. The issue is the Code Assistant will take 30s-1min to load. To make this worse, it doesn't seem to cache this information, so the tool becomes pretty unusable and we are forced to turn it off. It's not so bad working locally, but remote, even over a 100mb+ connection is pretty unusable.

Am I missing a configuration here that will cache this information or something?

Thanks

 

[Marco Kalter]

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

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

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

 

[suess]

Hi Marco - I PM'd you the contents of debug.txt