Database Tuning (MOSC)

MOSC Banner

Difference between baseline and sql_plan

edited Sep 12, 2018 8:47AM in Database Tuning (MOSC) 2 commentsAnswered ✓

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?

Tagged:

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