Database Tuning (MOSC)

MOSC Banner

How to make optimizer use baseline

edited Nov 6, 2018 10:49PM in Database Tuning (MOSC) 2 commentsAnswered ✓

I have situation where I have a good baseline but the optimizer will not use it. It insists on using a Plan Hash Value that is not shown in EM as either SQL Profile or SQL Baseline even though both exist. I have looked at DocIDs provided by Oracle but cannot seem to get the proper sequence. The starting Tuning job recommended new indexes which I launched in EM but one index had imbedded ' chars and failed. So, I manually created the indexes and Tuned again. This one said great plan and I implemented it but it wiped the

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