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.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center