Is it possible to run SQL Tuner without the plan table, QUEST_SL_EXPLAIN1, created in the schema SQL Tuner is running from? QUEST_SL_EXPLAIN1 is located in another schema and can not be created in the schema that is being used to run the tuner.
This is a limitation in the product that it will always try to use a plan table under the login schema.
WORKAROUND:
Have someone with the necessary privileges create the plan table. Once the plan table exists, the product will not prompt user to create it. Note that it would be the best to use the same script that prompted for the plan table to create it, to make sure that the plan table would also be recognized by the product again.
STATUS:
This enhancement has been released in SQL Optimizer for Oracle 7.3. This version can be downloaded at https://support.quest.com/SUPPORT/index?page=downloads.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy