How to kill hung JOBs in Oracle?

Question

Oracle

Good afternoon!
Please tell me how you can kill hung JOBs in Oracle, they are not removed through OEM using the "stop job" method, through

exec DBMS_SCHEDULER.STOP_JOB(job_name => 'Complexsql.J_Bank_Consolidation',force => TRUE);

it just hangs and doesn't output.
What is another way to kill them?

Answer 1

For good, you need to look for the hangup problem, and you need to try to kill using DBMS_SCHEDULER.STOP, if it doesn’t work, then you can also alter system kill session 'SID, SERIAL';

SELECT  V.SID,
           V.SERIAL#,
           J.JOB_NAME,
           'alter system kill session ' || '''' || V.SID || ', ' || V.SERIAL# || ''';'  KILL_SQL
      FROM dba_scheduler_running_jobs J
           left join V$SESSION V on V.SID = J.SESSION_ID