I have some queries that take several minutes to run (anywhere from 5 to 15). If I try to kill them by clicking the "Break" button, or by typing "Shift-Esc.", nothing happens. The only way to terminate the query is to try to exit the application. Usually I have to wait about 30 seconds for the file-save dialogue to appear. I click "Cancel" and then go back to work, but it's a little frustrating, especially because it doesn't seem to be 100% consistent. Any ideas why this might be happening? Is it the type of query? Could this be caused by something on the server (because the same query will not always exhibit this behaviour)? This only seems to happen with queries - scripts seem to terminate properly when I click the "Break" button.
Can't kill long running queries
- Thread starter Cube874
- Start date
The "Break" function sends a break signal to the server. This will usually break the current operation, but some operations like long internal sorts or locks it will not immediately break. In this case you can try to kill the session.
If you have alter system privileges you can do it from the Session menu (or shortcut key or toolbar button). You can also do it from the Sessions tool.
Similar threads
