查询
SELECT T2.USERNAME, T2.SID, T2.SERIAL#, T2.LOGON_TIME
FROM V$LOCKED_OBJECT T1, V$SESSION T2
WHERE T1.SESSION_ID = T2.SID
ORDER BY T2.LOGON_TIME;
构建的 删除语句
select distinct 'Alter system kill session ''' || T2.SID || ',' || T2.SERIAL# || '''' || ';'
FROM V$LOCKED_OBJECT T1, V$SESSION T2
WHERE T1.SESSION_ID = T2.SID
and T2.USERNAME ='哪个用户'