Cancel executing query programmatically
I want to stop queries that executes for a long time.
I know that there is "Ctrl+C" or "Cancel Button" in sqlplus.
But How can I do it progmmatically, for example: in Delphi. I don't want you to give me example for Delphi, I mean which steps I have to do in order to do it?
Thanks in advance!!!
If your using scripts then u can kill the script
kill -9 scriptname
Or kill the session
alter system kill session 'sid,serial#';
Or even.. Kill the tread/process at OS level
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
a more elegant approach would be to create a resource plan and consumer groups so that users in X group can be limited to things like how much max execution time, undo quota , cpu usage etc
I'm stmontgo and I approve of this message
Click Here to Expand Forum to Full Width