how to kill a query from sqlplus

[maswien]

I started a long query from my oracle client. Then it keeps running and won't come back, I want to kill it but seems no way, any idea? Thanks

 

[Turkbear]

If still in SqlPlus just use the File..Cancel ( if it is returning records)..

Otherwise go into the Enterprise Manager ( or some other DBA tool) and Kill the session..





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[SantaMufasa]

Maswein,

I agree with Turkbear. Additionally, I try a [ctrl-C] (with a light seasoning of [ctrl-D]), and if that doesn't work, I liberally sprinkle with the 'X' in the upper right corner of your Window...It's usually faster to do that and to re-connect to Oracle than to wait for a "interminable" query to finish.

Too bad that Oracle hasn't created a [Cancel Query] button...like, how hard is that?

Mufasa
(aka Dave of Sandy, Utah, USA)
[

http://www.dasages.com:

Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.