Discussion on Doc ID 2025019.1(How to Use the DBMS_SQLPA (SQL Performance Analyzer) API to Test Data

Hello experts,

                       I believe this is really a great alternative approach where we don't need to collect execution statistics by remote execution through db link.I have tried this approach several times and it works and it worked theoretically but I have a little doubt with the report.I am attaching some sample report where you can see most of the cased sqlplan baseline has been used by the query during post upgrade execution.I did not create those STS but those came when I imported STS in my target database where I am testing impact of database upgrade.

My question is if query uses plan baseline then certainly plan will not change and how can we rely on that report.If my understanding is wrong please correct me.