select
b.sid,b.SERIAL#,b.username,a.sql_text
from
v$sqltext a,
v$session b,
v$process c
where
b.username='ORACLEUSER'
and
c.addr = b.paddr
and
b.sql_address = a.address and b.status='ACTIVE'
order by b.sid
alter system kill session '45,20' immediate
