oracle 查询死锁 删除

查询

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 ='哪个用户'