Debug stopped Database

[M. Rokus]

Hi,

I debugged a Package with the developer 7.0.0.1050, but while I start the debugging, the developer hangs up. A few people informed me, that they couldn`t work with the database anymore. We find the debug session of the developer which execute:
declare
ret binary_integer;
begin
ret := PBSDE.DEBUG_LOOP;
end;

After we killed this session, the database works normal.
Is there a solution for this problem?

Thanks for the reply,
Markus

 

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