Problem when start to debug

[Ceco]

Hi,
I have a big problem when decide to start debug. It makes some kind of initializations that take too long time to finish /Maybe it compiles dependecies or something like that , but the PL/SQL Developer hangs when I try to debug/. I'm using the last version set for download 6.0.6.947.
Also, I didn't find any settings related to that problem in the application.
Can someone give me a solution?
Thank you in advance.

 

[Marco Kalter]

There are 3 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. 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.

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