select 'alter system kill session ' || '''' || a.SID || ',' || a.SERIAL# ||
''''||' ;'
from v$session a
where a.username = 'GF_HR_USER'
and a.STATUS = 'ACTIVE'
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/15747463/viewspace-750760/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/15747463/viewspace-750760/