V9 Not Responding when running SQL

[StevenRowe]

Problem did not exist in V7. I thought PL/SQL Dev was multi threaded but I may go back to V7 now

 

[Marco Kalter]

Can you let me know the exact symptoms?

 

[StevenRowe]

Can you let me know the exact symptoms?

I open an SQL file click F8 to run, then open another window/file and do the same. The PL/SQL Title Bar then displays (Not Responding) I cannot tab between the two windows and the timer stops incrementing.

Therefore, I don't know if the script is still running or if I should abort the program and start again. Wherupon I am likely to meet the same scenario.

Any help is appreciated.

 

[Marco Kalter]

Can you let me know the "Session Mode" preference (Tools > Preferences > Oracle / Connection)?

 

[StevenRowe]

Can you let me know the "Session Mode" preference (Tools > Preferences > Oracle / Connection)?

Session Mode > Multi Session
Allow Mutiple Connections > Checked

 

[StevenRowe]

However, it does actually return. 1 script took 1172:05 but has produced results and window is now responding!

Is there a limit as to the number of scripts you can run or amount resource you can use?

 

[Marco Kalter]

There is no limit. 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).