PLSQLDeveloper SQL execution slowdown whit many predefined connections

[Lampy]

We found out that total SQL execution time deteriorates with many defined connection. A particular SQL was executed in 0,15 seconds when there were no fixed connections defined, just 12 different recent connections.

After I imported 195 connections, the execution time of the same SQL dropped down to 0,85 seconds.

We lost a day of work hunting down SQL performance issues because of this PLSQLDeveloper bug (in our view at least).

 

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

 

[Lampy]

I have uploaded debug log to my Dropbox.

Dean