SQL Performance (MOSC)

MOSC Banner

sql uses sql plan baseline only sometimes.

edited Apr 26, 2016 5:07AM in SQL Performance (MOSC) 1 commentAnswered

If there is a reproducible sql plan baseline why would a query only use it sometimes.  I notice an particular sql which sometimes uses sql plan baselines and sometimes not. That kind of defeats the purpose of sql plan baseline.  Have you see this behaviour.  Database version is 12.1.0.2

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