470,581 Members | 2,438 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,581 developers. It's quick & easy.

Stop an oracle SQL statement


Little niggling problem I have - just wondered if anyone has any ideas...

Is there a way to stop an SQL statement once it has been sent to Oracle?

Now I always thought the answer was no, but I have started using the free
(and very good) SQLTools - in which you can start an SQL statement, but you
can also cancel it and SQLTools then stops the execution of the sql on the
oracle box (it does not leave a duff ora process or anything).

I thought this might be useful if we have long running queries on web pages
(due to DB problems for example) and we could have a timeout which will do a
controlled shutdown of the query and the db connection, rather than
server.timeout which leaves an active ora connection - leave too many of
these and you could run out of handles r run up huge CPU-gobbing processes

any ideas??

Jul 19 '05 #1
0 1614

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by francis70 | last post: by
reply views Thread by JWM | last post: by
11 posts views Thread by Markus Breuer | last post: by
1 post views Thread by Andrew Arace | last post: by
6 posts views Thread by sarat | last post: by
56 posts views Thread by Ashish Patankar | last post: by
3 posts views Thread by Tony Marston | last post: by
1 post views Thread by livre | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.