Oracle: Sessions anzeigen und beenden

select s.sid, s.serial#, p.spid, s.username, s.schemaname, 
s.program, s.terminal, s.osuser, s.process, s.status, sql.sql_text
from v$session s
join v$process p on s.paddr = p.addr
LEFT JOIN v$sql     SQL ON sql.sql_id = s.sql_id
where s.type != 'BACKGROUND'

ALTER SYSTEM KILL SESSION 'sid,serial#'