1、查看正在运行的job;
SELECT * FROM USER_SCHEDULER_RUNNING_JOBS
2、根据sid查出对应的session;
select SID,SERIAL# from V$Session where SID=690;
3、kill对应的session;
alter system kill session '690,15126';