PL/SQL Developer slow querying dictionary objects

[Matt Symes]

Is there a debug mode or anyway of getting a trace from PL/SQL developer itself when it tries to query objects from the data dictionary.

I love PL/SQL Developer (currently using version 7) but it's very slow using it at my current client site and I'd like to understand why and then hopefully work with the DBAs to resolve.

Regards,

- Matt Symes

 

[Marco Kalter]

You can modify the PL/SQL Developer shortcut and add the DebugSQL parameter. For example:

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

This will create a 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).

PL/SQL Developer Version 7 may indeed have some performance issues on Oracle10g and later. The current version 9 should fix this.

 

[Matt Symes]

OK - I've got a Debug.txt file. Can I mail to you to take a look?

Don't think version 7 should be poorly performing with 10g. 10g was around well before version 7 I think.

 

[Marco Kalter]

Yes, you can send it by e-mail to support.