Session browser, explain plan for current statement tab will not display results
Scenario: User A running a Select * from Table_Name. The user then connects to the database as a DBA user. The user then goes to DBA >> Session Browser and selects USER A. On the right Tabs the user selects Current Statement. On the Bottom the user selects the Explain Plan Tab. The explain plan states "Objects referenced in the SQL may not be available to current user."
The user can right click on the explain plan and selects either option "Use Connected user/schema" or "Always set session to statement user", but they are unable to resolve the error.
WORKAROUND Option 1 1. Go to View >> Options >> General -> Uncheck �Use a separate connection when TOAD itself is generating transactions�
Option 2 1. Make sure that the DBA user has access on User A�s Table by going into the SQL Editor and running an explain plan for the select statement, 2. Go to View >> Options >> Oracle. Locate the "Explain Plan Table Name" currently used. 3. Go to Tools >> Object Search. Search for the current Explain Plan Table name (Found From step 2) under all users 4. If more than one Table is found delete or re-name the table.
STATUS This issue is fixed in Toad for Oracle 9.0. This version can be downloaded at http://questsupportlink.quest.com/prod_upgrade_alert.asp.