Kill Oracle query

• Find the query

SELECT s.sid,s.serial#,s.machine, oc.user_name, oc.sql_text
FROM v$open_cursor oc, v$session s
WHERE oc.sid = s.sid and lower(sql_text) like '%your text%' ORDER BY lower(sql_text) DESC; 

• Kill the query

ALTER SYSTEM KILL SESSION 's.sid,s.serial#';