Locked Tables and Session hangs when Debugging (4332533)

When debugging Package procedures and functions which are running DML (Insert, Update, Delete) statements against tables, Oracle automatically places a lock on the table until this resource is finished and/or the Debug session has completed its execution. The Debug session can hang if it surpasses the Debug Timeout while waiting for this resource/table to be unlocked by another session. If the Debug Session hangs, this will leave an orphaned session in limbo affecting any subsequent Debug sessions until Oracle's PMON process kills this process.