Database Tuning (MOSC)

MOSC Banner

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?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center