[Oracle]尋找並kill指定session

select p.SPID, s.username, s.sid || ',' || s.serial# "ID", s.status, s.last_call_et "Last Activity", b.sql_text from v$session s, v$sqlarea b, v$process p where s.username is not null and p.addr = s.paddr and s.sql_address=b.address;

ALTER SYSTEM KILL SESSION 'sid,serial#' IMMEDIATE;

sid,serial# = 第一句sql的ID column