There have been a number of instances where Toad can take over ten minutes to cancel a query. I’m currently waiting on a query to cancel that just went over fifteen minutes, and it’s still going. Out of curiosity, can someone give me some insight into what goes on behind the scenes such that cancelling a query takes as long as it does?
UPDATE: After waiting 35 minutes for the query to cancel, I killed Toad via the Task Manager. I have no idea why the query sat in the “cancel pending” status for that long.