Stop query
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Stop query

  1. #1
    Join Date
    Feb 2001
    Location
    Bangalore, India
    Posts
    109
    If a query is running for too long, is it possible to stop it without killing that session?

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Killing the session is the only option I know of.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Nov 2000
    Posts
    344
    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

  4. #4
    Join Date
    Feb 2001
    Location
    Bangalore, India
    Posts
    109
    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?

  5. #5
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    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
    Thanx
    Sam



    Life is a journey, not a destination!


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width