SQL Developer hangs for minutes

jd0

Member
Hello,

When I right-click on a package name and select "View Spec & Body", the program just hangs for a LONG time (minutes at a time).
Sometimes, the package Spec is displayed very fast, but the Body takes so much time that the program becomes not responsive, and windows sometimes asks me if I want to close the program.
This also happens sometimes when I right-click a package name.
If I let it rest for long enough (like I said, It takes sometimes over 10/15 minutes for the program to "unblock").

Is this a known issue? It's almost impossible to work like this..

Please, I really need a quick reply!

Thank you in advance
 
Last edited:
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).
 
Thanks for the help, but I had the IT staff format my computer and it seems to work now... If it happens again I'll do that and send the file.

Thanks again.
 
Back
Top