PL/SQL Developer Slowness

[Val]

Debugger is really slow when I try to debug a Procedure in a Test window. Once it opens the Procedure screen it takes about 30-40 seconds for the debugger to jump from one line of code to another. It's really annoying... I must mention we migrated the server to Oracte 10g, but the client is still Oracle 9i.

Do you have any idea why the performance is so bad?

Thanks,
Val

 

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

 

[Val]

Thanks for the reply. Today it was a little bit faster. Instead of 30seconds per line of code, the debugger spent around 5-10 seconds. But it is still annoying when you wait 10 seconds for simple things like nCnt := nCnt + 1.

The file was too long to be posted here. Sent e-mail instead.

Thanks for helping us with this.