Time hungry Procedure Hangs PL/SQL Dev

[Joe]

I am using PL/SQL Dev ver 6.05.926
The package executes fine on a small set, however, when there are many thousands of records to process, after sometime (random) pl/sql dev hangs.
Is this common? What is the solution?

 

[ScottMattes]

Nope, not common at all. I have used it on x,xxx,xxx of rows.

 

[Marco Kalter]

Does this hang-up occur during execution or compilation?

 

[Joe]

During execution of the proc in the pack.

 

[Marco Kalter]

Are you using Multi-Session Mode or Dual-Session Mode? In either case PL/SQL Developer cannot hang during execution of a program unit, since this happens in a background thread in a separate session. You may need to cancel execution or kill the session, but it will not literally hang.

 

[Joe]

I am using multi-session mode. when it 'hangs' pl/sql dev stops responding completly and any further mouse clicks on it results in 'Not Responding' shown in the title of pl/sql dev.
Are you suggesting then to kill the session through another instance of pl/sql dev?

 

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

 

[robl]

I am having a similar problem but it does not have to do with compiling. After every click throught the application the app becomes frozen and on mouse clicks the [Not Responding] message is added to my applications title bar. Just about every screen i go to makes me wait between 5 and 30 seconds...

 

[robl]

OK so it happens most when I am compiling or have just ran an execution of a sql statement. The result set is completed but the black cancel lightening bolt is enabled.