检索Oracle 锁住的表和解锁

 

Sql代码:

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;

 

 

用这条语句检索出被锁的信息。

 

 

再执行

Sql代码: alter system kill session '[SID],[SERIAL]';