SQL Plan Management - Manually loading baseline
Hi
We have 2 different sets of AWR Snapshots.. about a week apart
First set
Begin Snapshot --> 10240
End Snapshot --> 10250
Second Set of AWR snapshots
Begin Snapshot --> 10331
End Snapshot --> 10336
We would like to load the SPM baseline using both the above AWR snapshots sets since they both contain SQL from different applications that we need to have in the baseline.
We are assuming that we can run the dbms_spm.load_plans_from_awr multiple times using different start and end snap ids and we should be ok doing that. Correct?
Also, should we first create a STS from those AWR snapshots and then load the STS OR should we directly load it from AWR bypassing the STS step?