SQL Performance (MOSC)

MOSC Banner

Understanding optimizer_use_plan_baselines

edited Feb 5, 2018 4:05AM in SQL Performance (MOSC) 2 commentsAnswered

In case

optimizer_use_sql_plan_baselines=true and optimizer_capture_sql_plan_baselines=false since the beginning of the database being upgraded.

Does that mean that SQL plan baselines would not be created, and no plans would be added to baselines. As per my understanding initally we need to enable the capture parameter to get the first accepted plans in the baselines. As after 2nd execution in case capture _sql_plan_baselines is true then only the plan is added to the baselines.

Next Questions is

I set the capture_sql_plan_baselines=true at session plan and it generates few plans after multiple execution

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