Can the Toad Explain Plan show SQP Profile usage? I am using the Oracle SQL Tuning package and have realized that knowing which SQP Profiles is being used is a critical piece of information when looking at a SQL statement. The Automatic Tuning Optimizer generates profiles that can either be manually accepted or automatically accepted and these profiles limit the execution plans the optimizer will generate. It would be very helpful to know that one of these profiles was influencing the explain plan.
WORKAROUND:
None
STATUS:
Enhancement request has been submitted to Development for consideration in a future release of Toad for Oracle.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy