Unstable When Debug

[poei]

Hi,

When debugging a Package and you step through triggers the debug windows hangs. Then you need to kill pl/sql and start again.

This happens intermittendly.

Please advise.

PL/SQL Developer
Version 7.0.3.1095 (MBCS)
01.34225 - 5 user license
Windows XP version 6.0 (build 2600) Service Pack 2
Oracle 10g

 

[Marco Kalter]

I see you are using the 7.0.3 beta. Does this also happen with 7.0.2?

 

[poei]

I have changed back to 702 and i get the same issues.

 

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

 

[Albert]

What about some trigger on the system error? Usually it's a cause!!!

 

[Albert]

You can test it. Disable or drop such trigger and you will never see such error.