error_prone
asked on
Pause or Break TOAD Queries
In TOAD's SQL Editor, can I force a query timeout or do a pause or break in a query I'm trying to run if it takes too long? I'm trying to stop queries that take too long without having to CTRL-ALT-DELETE on TOAD altogether.
Last Comment
Select SQL / Run Query From Thread. This will allow you to cancel the query when it's running. There should also be an icon for it on your tool bar.
ASKER
I don't see Run Query From Thread anywhere. It's usually too frozen for me to select the Cancel button.
What version are you running?
ASKER
8.0
ASKER
Not sure what I'm supposed to look for in that lengthy article...
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Not really...using TOAD for work. So CTRL-ALT-DELETE it is then?
ASKER
Ok, wait I see Process Statements In Threads/Allow Queries to Be Cancelled in the Options section under SQL Editor and I checked and am running a query but shouldn't there be a cancel button somewhere for me to actually cancel it? I'm not seeing one...
Are you looking in the SQL Editor? Let me know if you found it or not.
Look at View / Options / SQL Editor. Process statements in threads. Then you can cancel from the SQL Editor toolbar. Another second technique / method is, from SQL Editor, you can also run in background, and cause a new window to open. This new window can be closed to cancel the query.
Oracle Database
Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.
81K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
