Lockup during Export User Objects from Remote DB

[rjoffe]

We are experiencing problems when exporting user objects from remote databases. The problem symptoms are of PL/SQL Developer jsut locking up during the middle of the export when we have chosen multiple (all) objects to export.

The only solution is to end-task the app and start over.

This issue only seems to occur on remote, and not local databases. A concurent ping to the remote system shows the connection does not stop during the export process.

Any suggestions ?

 

[Marco Kalter]

Does PL/SQL Developer lock up, or does the Export function stop responding? Can you also let me know your "Session Mode" preference?

 

[rjoffe]

Marco,

Thanks for the quick response.

There is a clock cursor active, and I am not able to utilize any PL/SQL function (i.e. all locked up).

I have tried all Session Modes, same issue. Currently utilizing Multi.

What else can i provide to try and track down this issue?

Ron

 

[Marco Kalter]

To obtain some more diagnostic information, can you modify the shortcut and add the debug parameter? For example:

"C:\Program Files\PLSQL Developer\plsqldev.exe" debug

Reproduce the problem and send me the debug.txt file that is generated in the PL/SQL Developer directory.