--C#内执行ExecuteNonQuery查询数据时卡死问题
--查询数据库中锁死表记录
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;
--查询锁死SID的serial#
SELECT sid,serial# FROM v$session WHERE sid = 2275;
--结束锁死进程 alter system kill session 'sid,serial#';
alter system kill session '2275,8151';