Saturday, May 21, 2011

How to Kill an Oracle SQL query if SQL text and Oracle User are known

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

No comments: