Print Thread
Window/tab execution frozen
#44475 08/27/12 07:11 AM
Joined: Mar 2008
Posts: 29
Oslo, Norway
S
Stian Offline OP
Member
OP Offline
Member
S
Joined: Mar 2008
Posts: 29
Oslo, Norway
Hi,

I have been getting a lot of execution freezes now in a tab/window where I execute a simple select * from table. This table just got populated.

Test case
1. open file (is opened in main connection)
2. change connection to correct one only in this tab/window
3. execute select works OK
4. populate table (script in same window) works OK (same result with commit or no commit)
5. select table works OK
6. select table again freezes this tab, no other commands done since last select.

At this point it says Executing... and I'm unable to Break the query. Closing the tab/window it asks to terminate as a query is still executing. This works ok. And I can re-open the sql-file with the code.


Last edited by Stian; 08/27/12 07:54 AM.

Regards
Stian
Re: Window/tab execution frozen
Stian #44477 08/27/12 07:59 AM
Joined: Mar 2008
Posts: 29
Oslo, Norway
S
Stian Offline OP
Member
OP Offline
Member
S
Joined: Mar 2008
Posts: 29
Oslo, Norway
I have an unusual oracle-home config.

We are using Oracle Designer and it has it's own 10g home and I have 11gR2 enterprise 64-bit. For PD I use instantclient 11gR2 32-bits with the oracle home and OCI path entered in the preferences.

TNS_ADMIN is set to the 11gR2 enterprise 64-bit database.

It seems I am not able to post the Support info. It gets clipped after "Physical memory : 4" every time.

Support info:
PL/SQL Developer
Version 9.0.6.1665
Windows 7 (64-bit) 6.1 Build 7600

Physical memory : 4

Last edited by Stian; 08/27/12 08:07 AM.

Regards
Stian
Re: Window/tab execution frozen
Stian #44482 08/27/12 09:43 AM
Joined: Aug 1999
Posts: 22,173
Member
Offline
Member
Joined: Aug 1999
Posts: 22,173
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.057s Queries: 15 (0.017s) Memory: 2.5030 MB (Peak: 3.0393 MB) Data Comp: Off Server Time: 2024-03-28 15:04:48 UTC
Valid HTML 5 and Valid CSS