--查询锁死任务
SELECT object_name, machine, s.sid, s.serial#
FROM gv$locked_object l, dba_objects o, gv$session s
WHERE l.object_id = o.object_id
AND l.session_id = s.sid;
--终止锁死任务
ALTER SYSTEM KILL SESSION '158,8294'
--终止失败查询需要在服务器上执行命令kill的进程编号
select spid, osuser, s.program
from v$session s,v$process p
where s.paddr=p.addr and s.sid=158
--linux系统杀进程
kill -9 上面查询的spid
--windows杀进程
orakill 数据库名 上面查询的spid
SELECT object_name, machine, s.sid, s.serial#
FROM gv$locked_object l, dba_objects o, gv$session s
WHERE l.object_id = o.object_id
AND l.session_id = s.sid;
--终止锁死任务
ALTER SYSTEM KILL SESSION '158,8294'
--终止失败查询需要在服务器上执行命令kill的进程编号
select spid, osuser, s.program
from v$session s,v$process p
where s.paddr=p.addr and s.sid=158
--linux系统杀进程
kill -9 上面查询的spid
--windows杀进程
orakill 数据库名 上面查询的spid