test and debug step by step freezes the system

[Kazshu]

Hi!

In severeal cases PLSQL being frozen during testing a package procedure if debbug option is on, and we use step-by-tep debugging or run to break point. Server: Oracle 9.2, Client: Oracle 8.1.7. What's the reason it? Is there any sollution?

 

[Marco Kalter]

There are 2 things you can do:

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.