Intermittent Hangs on v7.1.5

[Andrew Murphy]

Hi,

We have around 30 users of PL/SQL Developer and many of them report that they frequently experience the application hanging which can only be cured by forcing the application closed, restarting and using the recovery file to restore their work.

The most common times this will happen is when opening a package specification and body (the specification displays then the application will hang) and when expanding one of the navigator items (even when filters are set to 'My Objects'). We also see it while running queries (it will say 'initializing' and then just hang). This isn't just a case of poor performance as we've left hanging sessions for hours without them responding.

We get this while connected to our Oracle 9i and 10g databases and will happen several times per day.

We've lived with this for a year or so now as an inconvenience but now the issue is being used as a reason to stop using the product and switch to something like SQL Navigator or TOAD.

Does anyone have experience of this issue?

Thanks,

Andrew Murphy
Teleplan International

 

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