Print Thread
Debugger hanging
#29286 02/21/08 09:35 PM
Joined: Nov 2007
Posts: 13
Dallas, TX USA
U
Member
OP Offline
Member
U
Joined: Nov 2007
Posts: 13
Dallas, TX USA
I am getting a debugger issue in PL/SQL Developer


Thanks very much!
Re: Debugger hanging
#29287 02/21/08 10:41 PM
Joined: Nov 2007
Posts: 13
Dallas, TX USA
U
Member
OP Offline
Member
U
Joined: Nov 2007
Posts: 13
Dallas, TX USA
Addendum:
Ran some DBA queries and looks like my session is waiting on a dbms-pipe message, but the message isn


Thanks very much!
Re: Debugger hanging
#29288 02/22/08 04:35 PM
Joined: Aug 1999
Posts: 22,216
Member
Offline
Member
Joined: Aug 1999
Posts: 22,216
The dbms_pipe is used internally be the Oracle's debugger subsystem. There are 4 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. Disable the call stack.

Go to Tools > Preferences > Debugger and disable the "Update call stack after each step".

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


Marco Kalter
Allround Automations
Re: Debugger hanging
#29289 02/26/08 10:59 AM
Joined: Jan 2008
Posts: 11
I
Member
Offline
Member
I
Joined: Jan 2008
Posts: 11
Thanks Marco. I had the same issue. Resolved it after following your steps 1 and 3(Re-installed dbms_debug and Disabled the call stack)


Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.028s Queries: 12 (0.010s) Memory: 2.5115 MB (Peak: 3.0420 MB) Data Comp: Off Server Time: 2024-05-12 13:53:55 UTC
Valid HTML 5 and Valid CSS