PL/SQL Developer periodic hanging...

[Electrokardiogram]

On occasion, PL/SQL Developer hangs after I issue a SELECT ... FROM .... FOR UPDATE, and the query results never appear. PL/SQL Developer locks up, and the only way to exit is to force a close via the Windows Control Panel.

Although this has happened several times in the past, I was able to issue FOR UPDATE requests upon re-entering the application after the forced close. Yesterday, however, I was not able to issue FOR UPDATE requests for about 2 hours, even after having closed the application.

How can I resolve this problem? Is this a PL/SQL Developer problem, or an Oracle 10g problem? Any assistance is much appreciated.

 

[Stew Stryker]

Have you tried using the Session Monitor to see if your process is hung up in a wait state? Just a WAG.

 

[Marco Kalter]

Perhaps you should omit FOR UPDATE clause, or use FOR UPDATE NOWAIT instead. This way you will never get a locking issue.