PL/SQL Developer freezing constantly

[will_s]

Hello,

I have used PL/SQL Developer for a while now and I enjoy the product. In the past from time to time the product would freeze and I would force close it and re-open with no issues. More and more lately it has been freezing. 8 times in the past hour as I have tried to compile a package in our UAT environment.

I tried making the exe start in administrator mode and I also turned on compatibility mode for Windows 7.

I am on Windows 7 Enterprise 64 Bit.

My PL/SQL Developer version is: Version 12.0.5.1828 (64 bit)

Let me know if there is any more information that will be helpful.

 

[Marco Kalter]

If you are experiencing locks during compilation, it may be that the program unit is locked (used/executed) by another user. To prevent that PL/SQL Developer freezes during compilation, you can enable the "Background compilation" option from the Preferences > Program Window section. Now all compilations will be performed in a separate database session and in a separate background thread.

If this does not help, then to obtain some more diagnostic information, can you modify the shortcut and add the DebugSQL parameter? For example:

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

Reproduce the problem and send me the debug.txt file that is generated in the %APPDATA%\PLSQL Developer 12 directory (e.g. C:\Users\\AppData\Roaming\PLSQL Developer 12).

 

[will_s]

I will try what you suggested and post logs if it doesn't work. Thanks!