Hangs when debug

[Terry R]

PLSql Developer hangs with a 'wait cursor' during a debugging session.

Usually happens some minutes into a debug session. The cursor is not hovering over a variable or any other piece of code.

The problem does not occur when you turn 'Show variable values in a popup' off.

Support Info:

PL/SQL Developer
Version 7.1.4.1390
06.41288 - 5 user license
Windows XP Professional 5.1 Build 2600 (Service Pack 2)

Physical memory : 2,086,980 kB (881,840 available)
Paging file : 2,703,964 kB (1,636,836 available)
Virtual memory : 2,097,024 kB (1,907,456 available)

Parameters
C:\Program Files\PLSQL_Developer\plsqldev.exe

Preferences
Session mode: Multi
OCI Library:
Use OCI7: False

Preference Files
C:\Program Files\PLSQL_Developer\Preferences\Default\Default.ini
C:\Program Files\PLSQL_Developer\Preferences\reevet\default.ini

Plug-Ins
*Quick/ER - Gotterup.Net (C:\Program Files\PLSQL_Developer\PlugIns\QuickERPlugin.dll)
(* is Active)

Aliases
BEQ-LOCAL.WORLD
BNDACC
BNDBLD
BNDBLK
BNDCUT
...

Homes
OracleHome (c:\OraNT)
OracleReports (c:\OraNTRpts)

DLLs
c:\OraNT\bin\oci.dll

TNS File
c:\OraNT\Network\Admin\tnsnames.ora

Using
Home: OracleHome
DLL: c:\OraNT\bin\oci.dll
OCI: version 9.2
Oracle9i Release 9.2.0.8.0

Character Sets
Character size: 1 byte(s)
CharSetID: 31
NCharSetID: 2000
Unicode Support: True
NLS_LANG: ENGLISH_AUSTRALIA.WE8MSWIN1252
NLS_NCHAR_CHARACTERSET: AL16UTF16
NLS_CHARACTERSET: WE8ISO8859P1

 

[Marco Kalter]

You could try the following:

1. Increase the shared pool size.

The Oracle Debugger seems to have some stability issues when there is not enough free memory in the shared pool.

2. Disable the call stack.

Go to Tools > Preferences > Debugger and disable the "Update call stack after each step".

3. Check for user trace files on the server.

It may be that the server process has died. Check if a trace file exist that is related to the problem, and if so, send it to me.