QUESTION:
We have a procedure that we schedule to run every night through dbms_jobs. This ran fine for 6 months and then it failed mysteriously. It shows up on the dba_jobs_running view but it doesn't appear to be doing anything. It has been hung for a few days. Please tell me How can I remove this entirely from the dba_jobs_running view?