select 'alter system kill session '||''''||t2.sid||','||t2.serial#||''';'
from gv$locked_object t1,gv$session t2
where t1.session_id=t2.sid order by t2.logon_time;
获取查询结果后:批量执行查询语句,进行批量解锁
select 'alter system kill session '||''''||t2.sid||','||t2.serial#||''';'
from gv$locked_object t1,gv$session t2
where t1.session_id=t2.sid order by t2.logon_time;
获取查询结果后:批量执行查询语句,进行批量解锁