oracle中查看表是否被锁查看表是否被锁SELECTa.sid, b.owner, object_name, object_typeFROM v$lock a, all_objects bWHERE TYPE = 'TM'and a.id1 = b.object_id;
这样可以把它杀掉SELECT sid,serial# FROM v$session WHERE sid =&sid;alter system kill session ‘sid,serial#’;