oracle 解除记录死锁

一个解锁的SQL
杀进程(解锁):
set echo on
rem 该脚本是用来检验系统中谁在锁表
column username format a13
column object_name format a20
column machine format a15
column program format a20
select A.SID,b.serial#,c.object_name,b.username,b.machine,b.program
from v$lock a,v$session b,all_objects c
where a.sid=b.sid and a.type in ('TM','TX')
and c.object_id=a.id1
order by username
/
SELECT 'alter system kill session '||''''||TO_CHAR(sid)||','||TO_CHAR(serial#)||''''||';'
from v$session
WHERE SID=&SID
/

example:
ALTER SYSTEM KILL SESSION '13, 8';
 

本文来自CSDN博客，转载请标明出处：http://blog.csdn.net/cc163/archive/2007/03/05/1521050.aspx