select * from dba_jobs_running --假定jobno是224
begin --先执行这个 ,停掉定时任务
dbms_job.broken(224, true, sysdate);
commit;
end;
select * from dba_jobs_running where job='224';
select * from v$session where sid='9';
select b.sid,b.serial# from dba_jobs_running a, v$session b where a.sid=b.sid and a.job='224';
alter system kill session '586,41405'; --如果报错(标记要中止的绘画,则用下面的方法linux杀进程)
-
SELECT l.session_id sid, --查看是否锁表
-
s.serial#,
-
l.locked_mode 锁模式,
-
l.oracle_username 登录用户,
-
l.os_user_name 登录机器用户名,
-
s.machine 机器名,
-
s.terminal 终端用户名,
-
o.object_name 被锁对象名,
-
s.logon_time 登录数据库时间
-
FROM v$locked_object l, all_objects o, v$session s
-
WHERE l.object_id = o.object_id
-
AND l.session_id = s.sid
-
ORDER BY sid, s.serial#;
select spid, osuser, s.program from v$session s, v$process p where s.paddr = p.addr and s.sid =586; --查询出SPID
LINUX 下 kill -9 SPID 即可