select Distinct 'alter system kill session '||chr(39)||b.sid||','||b.serial#||chr(39)||';' As cmd,b.username,b.logon_time from v$locked_object a,v$session b where a.session_id=b.sid
本文共 230 字，大约阅读时间需要 1 分钟。
select Distinct 'alter system kill session '||chr(39)||b.sid||','||b.serial#||chr(39)||';' As cmd,b.username,b.logon_time from v$locked_object a,v$session b where a.session_id=b.sid
转载于:https://my.oschina.net/liyonglee/blog/470298