Run queries as threads and sessions - Row Count and Explain Plan errors out. (4297035)

The option preference to "exectue queries in threads" does not work the same as version before 8.5.x. I used to be able to enable running queries in threads and the new threads would pick up the original sessions settings. This no longer happens and all new sessions ignore previously altered session changes." The alter session command applies to work done in the current window, but the alter sessions setting and other commands specific or depending on the session. like "Record Count" or Describing an object errors out.

Example:
All of this is performed with Execute Queries in Threads enabled/checked
1. Log into the database as USER1.

2. Attempt to run the following query:
SELECT acct_num FROM cust_acct;
This will throw the error "ORA-00942: table or view does not exist". This is expected as this object is in the USER2 schema, not USER1.

3. Execute the following statement:
ALTER SESSION SET CURRENT_SCHEMA=APPS;

4. Now re-execute the SELECT query.
This will run successfully and display the results.

If you right click in the results and select "Record Count" you get the error message "ORA-00942: table or view does not exist".

If you attempt to perform an explain plan you get the message "Objects referenced in the sql may not be available to the current user".

There have been changes in how Toad runs queries in threads, and how it uses sessions to do this.

WORKAROUND:

1. Uncheck the following option under View | Options | Transactions | "Execute Queries in threads (Creates a separate session)"

Or

2. Create a .sql file that contains the Statement to be executed.

STATUS:

An enhancement request has been submitted to Development for consideration in future release of Toad for Oracle.