Difference between baseline and sql_plan
Hello everybody,
Since many months ago, I´ve been creating a baseline per week (interval 7 days) through the command dbms_workload_repository.create_baseline in order to use these baselines after upgrade from 11.2.0.3 to 12.2.0.1 to avoid issue performance, but I´m not sure if this procedure is correct.
I think that I should use the sql_plan_management, even that I still don´t know how to use it, but I would like to understand which is different between the baseline from dbms_workload and baseline from dbms_spm.
So, May I affirm that the baselines from dbms_workload will be useful only to analyze and compare periods and the sql_plan to export and import queries execution plans in case of versions upgrade?