-
Title
Changes to cancel option when running a query. -
Description
When running a query, a pop up window appears with the cancel button and elapse time. How can a user change the settings so that instead of this pop up window, the cancel option is on the SQL Editor toolbar?
-
Cause
The difference in cancel option interface depends on whether Toad is executing or not executing queries in threads. If not executing in threads, the cancel option pop up holds focus so nothing else can be done in Toad.
-
Resolution
RESOLUTION 1.
In Toad for Oracle 8.0 and below:
a. Select View | Options | SQL Editor.
b. Check the "Process Statements in threads/allow queries to be cancelled" option.
c. Restart Toad.
RESOLUTION 2.
In Toad for Oracle 8.5 and above:
a. Select Views | Options | Oracle | Transactions
b. Check the "Execute queries in threads" option.
Unchecked (default) - Does not execute queries in threads and cancel button is in the pop up.
When working with View | Options | "Execute queries in threads (Create separate session)" unchecked, the query will run in one thread, showing the the popup with the cancel button and elapse time. In this case Toad must wait for the query to either finish or be cancled before any other work can be done in that Toad session.
Check - Executes queries in threads and cancel button is on toolbar.
When working with View | Optinos | "Execute queries in threads (Create separate session)" checked, Toad will create a separate session specifically to execute queries. A new session will be created for each query being run from the SQL Editor, Schema Browser, or Object Search window and there will not be a pop up. Instead the option to cancel will be enabled on the SQL Editor window's toolbar. Other work can be done in Toad while the query is running.