R
Rory
Hello,
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
etc...
any ideas??
rory
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
etc...
any ideas??
rory