oracle作业运行中,无法停止

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';

 

posted @ 2017-04-07 16:05  Leis  阅读(1506)  评论(0编辑  收藏  举报