Print Thread
V9 Not Responding when running SQL
#42658 11/08/11 11:32 AM
Joined: Apr 2007
Posts: 12
Glasgow
S
Member
OP Offline
Member
S
Joined: Apr 2007
Posts: 12
Glasgow
Problem did not exist in V7. I thought PL/SQL Dev was multi threaded but I may go back to V7 now

Re: V9 Not Responding when running SQL
StevenRowe #42667 11/09/11 11:09 AM
Joined: Aug 1999
Posts: 22,220
Member
Offline
Member
Joined: Aug 1999
Posts: 22,220
Can you let me know the exact symptoms?


Marco Kalter
Allround Automations
Re: V9 Not Responding when running SQL
Marco Kalter #42679 11/10/11 08:33 AM
Joined: Apr 2007
Posts: 12
Glasgow
S
Member
OP Offline
Member
S
Joined: Apr 2007
Posts: 12
Glasgow
[quote=Marco Kalter]Can you let me know the exact symptoms? [/quote]

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.

Re: V9 Not Responding when running SQL
StevenRowe #42683 11/10/11 10:09 AM
Joined: Aug 1999
Posts: 22,220
Member
Offline
Member
Joined: Aug 1999
Posts: 22,220
Can you let me know the "Session Mode" preference (Tools > Preferences > Oracle / Connection)?


Marco Kalter
Allround Automations
Re: V9 Not Responding when running SQL
Marco Kalter #42686 11/10/11 10:30 AM
Joined: Apr 2007
Posts: 12
Glasgow
S
Member
OP Offline
Member
S
Joined: Apr 2007
Posts: 12
Glasgow
[quote=Marco Kalter]Can you let me know the "Session Mode" preference (Tools > Preferences > Oracle / Connection)? [/quote]

Session Mode > Multi Session
Allow Mutiple Connections > Checked

Re: V9 Not Responding when running SQL
StevenRowe #42687 11/10/11 11:50 AM
Joined: Apr 2007
Posts: 12
Glasgow
S
Member
OP Offline
Member
S
Joined: Apr 2007
Posts: 12
Glasgow
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?

Re: V9 Not Responding when running SQL
StevenRowe #42698 11/11/11 10:54 AM
Joined: Aug 1999
Posts: 22,220
Member
Offline
Member
Joined: Aug 1999
Posts: 22,220
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\<User>\AppData\Roaming\PLSQL Developer).


Marco Kalter
Allround Automations

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.207s Queries: 15 (0.077s) Memory: 2.5208 MB (Peak: 3.0394 MB) Data Comp: Off Server Time: 2024-05-16 09:29:48 UTC
Valid HTML 5 and Valid CSS