SQL Performance (MOSC)

MOSC Banner

SQL Plan Management : SQL plan baseline is not used

edited Sep 3, 2016 5:00AM in SQL Performance (MOSC) 1 commentAnswered

I have a good query plan on 11g (query runs fast) but this query runs slow on 12c (query plan is different).

So I captured the query plan from cache, put it in a SQL Tuning Set and exported this.

This export was imported in 12c and the SQL Tuning Set was unpacked, the plan was loaded from the Tuning set into SQL Plan Management Base.

But now I cannot get the query to take the stored query plan in SPM.

Database 12.1.0.2 Enterprise Edition.

Parameter optimizer_use_sql_plan_baselines is set on TRUE.

The plan is available in the database, I can see it in "dba_sql_plan_baselines" with status ACCEPTED and ENABLED.

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