Debug Window Hangs

[kevb]

Hi

We have had some new oracle servers installed

We are now exprencing problems with the test debug window hanging when attempting to step through our code. Usually the first attempt goes through but subsequent attempts hang, however on some packages only occasionally the first attempt will go through.

Ive noticed some posts in the past on this matter, but none seem to have a fix?

We are using Devloper version 7.

 

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