oracle 数据库 解锁 被锁的表

1.查询 被锁的表

select object_name,machine,s.sid,s.serial# from v$locked_object l,dba_objects o,v$session s where l.object_id = o.object_id and l.session_id = s.sid;

2.解锁

alter system  kill session \’SID,SERIL#\’;