HOW TO CANCEL QUERY WITHOUT KILLING THE SESSION

exec dbms_system.set_ev(<sid>,<serial#>,10237,4,'');
exec dbms_system.set_ev(<sid>,<serial#>,10237,0,'');