oracle杀掉被锁住的进程

1.系统管理员登陆
2。—–查看被锁对象的序列号、sid

SELECT o.owner,o.object_name,o.object_type,s.sid,s.serial# 
FROM v$locked_object l,dba_objects o,v$session s 
WHERE l.object_id=o.object_id 
AND l.session_id=s.sid 
ORDER BY o.object_id,xidusn DESc

3.——利用sid 和序列号删除

alter system kill session '243,10265';

243是sid 10265是序列号