Extremely slow using 8.x & 9.x with 11g client and 10g DB

[Jason Gowins]

In the last year, we upgraded all of our databases from 9i to 10g. We have now begun the planning to move from 10g to 11g. However since our upgrade, we have noticed a masive speed degregation in the PLSQL product. Through the tool, queries that were quick are now suggish. Opening Packages have become painfully slow, some now taking a couple of minuites to open, insead of a couple of seconds. Also, with the code assistant on, it is amost unusable. When my DBA's log in using other tools, such as TOAD, they don't see any issues with speed. Additionally, our production systems don't show the same speed degregation. This is such a great product for our development team, we would really like to figure out what the problem is. Any help that would be provided would be greatly appreciated. I can provide any informaiton you think may be useful.

 

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

 

[brettw]

I have the same problem. We've an Oracle 11g new database and the Code Assistant is extremely slow for sql. I use PL/SQL Developer version 9.2. I had tried the method you suggested above Marco, but no DebugSQL file got generated in either location. I'm trying this out for a developer who highlighted the problem. She has a slightly older version of PL/SQL Developer. Wondering if possibly the Data Dictionary on the database that Code Assistant uses, is somehow messed up or is it PL/SQL Developer. Other databases it works fine.
Cheers.

 

[Marco Kalter]

Can you go to Help > Support Info, press the 'Copy all pages' button on this info screen, and paste this text into an e-mail reply?