天天看点

oralce 表被锁导致ExecuteNonQuery执行无响应,也不报错

1、找到锁表的SID
SELECT a.sid, b.owner, object_name, object_type FROM v$lock a, all_objects b WHERE TYPE = 'TM' and 
2、根据SID找到SERIAL
SELECT SID,SERIAL# FROM v$session WHERE sid = 73;
3、终止
alter system kill session '73, 10229';