Window/tab execution frozen

[Stian]

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.

 

[Stian]

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

 

[Marco Kalter]

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