oracle表解锁

楔子

学习笔记

查询被锁表以及解锁

select object_name,
       machine,
       s.sid,
       s.serial#,
       'alter system kill session ' || '''' || s.sid || ',' || s.serial#||''';' as "解锁sql"
  from v$locked_object l, dba_objects o, v$session s
 where l.object_id　 = 　o.object_id
   and l.session_id = s.sid;