解除oracle中表被锁

查看表是否被锁
set linesize 100
col OWNER for a8
col OBJECT_NAME for a14
col OBJECT_TYPE for a14
SELECT /*+ rule*/
a.sid, b.owner, object_name, object_type
FROM v$lock a, all_objects b
WHERE TYPE = 'TM'
and a.id1 = b.object_id;

查看死锁的语句：
select sql_text from v$sql where hash_value in
(select sql_hash_value from v$session where sid in
(select session_id from v$locked_object));


这样可以把它杀掉

SELECT sid,serial# FROM v$session WHERE sid = &sid;
alter system kill session ‘sid,serial#’;

统一命令 ：
col command for a46
col machine for a10
SELECT 'alter system kill session ''' || sid || ',' ||serial# ||''';' command,MACHINE FROM v$session WHERE sid = 377;


如：
SELECT sid,serial# FROM v$session WHERE sid = 414;
alter system kill session '414,59100';

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/83911/viewspace-674279/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/83911/viewspace-674279/