SQL Plan Management : SQL plan baseline is not used
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.