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.
é necessário estar conectado e ter um contrato de manutenção atual para visualizar os artigos de conhecimento premium.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center