Hello,

We have a problem, when we try to use debugging in plsql developer, sometimes It works perfectly, but after a long time we have to re-start the DBMS to continue with the debugging cause plsql developer gets locked when you try to debug, and after we start the DBMS It works perfectly again.

What Is going on ?? We have plsql developer 6.0.1. and oracle 9i

It's difficult to say. If it occurs after a long time, then maybe it's a problem with the database instance state, which may indicate a problem with the Oracle Debug API.

Well Marco, How do I see that? How can I solve the problem ?

It could be that you need to increase the global shared pool size. This can improve the stability of the Oracle Debugger.

See these threads for more info on this problem:

(1) PLSQL Developer hangs on PBSDE.DEBUG_LOOP (WAIT = pipe get).

(2) Debugger Hanging

Increasing the shared pool did not help us.

Try this sql:

select trigger_name from dba_triggers where TRIGGERING_EVENT = ('ERROR')

If you have a trigger with TRIGGERING_EVENT = 'ERROR', is big the possibility of hang. Try disable it and do a test..

If this don't work, see if you have any of this types of trigger too:

'LOGON',
'CREATE OR ALTER',
'CREATE',
'ALTER',
'ALTER OR RENAME',
'LOGON',
'LOGOFF',
'TRUNCATE'

select trigger_name from dba_triggers where TRIGGERING_EVENT in ('LOGON','CREATE OR ALTER','CREATE','ALTER','ALTER OR RENAME','LOGON','LOGOFF','TRUNCATE')

Try disable it too and repeat the test..

Good lucky