Developer Hanging

[Michal Dorsett]

We are using PL/SQL Developer version 5.0.3.527.
Often when we run tests in debug mode, the environment freezes, and the only way out of it is by using the Task Manager to kill the process.

We think this happens when placing the mouse over a variable during step debugging. This happens on a fairly regular basis.

We appreciate any help you can give us.

Thanks,

Michal

 

[Marco Kalter]

There are 2 things we can do to analyze this problem:

1. Reload the dbms_debug packages.

As a result of previous dbms upgrades, the dbms_debug packages can cause problems. You can logon to the server computer, go to $ORACLE_HOME/rdbms/admin, start SQL*Plus under the SYS account, and run pbload.sql. This will reload the dbms_debug packages. Check if this has a positive influence on the problem.

2. Check for user trace files on the server.

If the Test Window hangs, 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.

 

[sylvainchar]

I just solved the same problem by increasing the bd parameter shared_pool_size .

 

[Michal Dorsett]

How large did you make shared_pool_size?

Thanks,

Michal