ORACEL批量查锁，批量杀掉锁信息

生成批量杀锁命令

select 'alter system kill session '''|| sid ||',' ||SERIAL# ||''''||';'
from v$locked_object lo,
dba_objects ao,
v$session sess
where ao.object_id = lo.object_id and lo.session_id = sess.sid
ORDER BY sid ;

执行命令。