Stop query

[sln81]

If a query is running for too long, is it possible to stop it without killing that session?

[sambavan]

Killing the session is the only option I know of.

Sam

[jdorlon]

If the query is running from a multithreaded app there are ways to kill the session.

in SQL*Plus it's CTRL+C. In utilities like EZSQL and TOAD there is a cancel button. This sends a cancel command to the server from a separate thread in the same session.

But I think what you are really asking is how can one user kill another user's query. Killing the session is the only method that I know of.

-John

[sln81]

John, as a DBA I want to do that. A user is running a query from Discoverer tool. Gets an ora-3123 error. The query does not retrieve all the data. When that user tries to refresh the query, its giving another error ora-3127 telling that the prvious operation is not yet complete. As a DBA how can I solve it?

[sambavan]

Check the v$session for the user querry. Then kill that session. Then do
oerr ORA errornumber to see the cause and action to the errornumber.

Resolve the problem, and rerun the query to confirm that it works fine.

Sam