oracle 锁表查看和处理

1.查看表是否被锁

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 sid,serial# FROM v$session WHERE sid = &sid;

----------------

SELECT sid,serial# FROM v$session

WHERE sid in (SELECT /*+ rule*/a.sid FROM v$lock a, all_objects b WHERE TYPE = 'TM' AND a.id1 = b.object_id);

 可以把它杀掉

alter system kill session 'sid,serial#';