SQL Performance (MOSC)

MOSC Banner

Unable to create a plan baseline

edited Jan 28, 2020 5:43PM in SQL Performance (MOSC) 6 commentsAnswered

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?

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