Unable to create a plan baseline
Oracle 12.1.0.2 EE
I have a query that executes with a bad plan every few days. I'd like to create a plan baseline to avoid the bad execution plans. From the tuning adviser in OEM I'm told "All alternative plans other than the Original Plan could not be reproduced in the current environment." The statement is over 800 lines long.
The statement is an INSERT AS SELECT statement. I've seen conflicting information about plan baselines not being applicable for INSERT ... VALUES and INSERT AS SELECT.
If I can't use a plan baseline could I use a profile? For 12G it isn't recommended but is it my only option?