Database Tuning (MOSC)

MOSC Banner

Oracle not using my stored outline

edited Mar 31, 2009 2:49AM in Database Tuning (MOSC) 3 commentsAnswered
Created an outline using the sql_text obtained from v$sql on a poorly performing query, then created a private outline where I then edited the index name to one that will be more favorable, and then saved it back as a public outline.  I can see the changes in the all_outline_hints.  When I have the original program re-run, the outlines shows as used, however the execution plan being used is still with the old index and the outline indicators in v$sql show that it is not using the outline.

I've set all the parameters I know to set.  This is the only outline I'm using.  I've set USE_STORED_OUTLINES=TRUE  and I've set all other system parameters as per the documentation.  It looks like it should be taking the outline but it obviously is not.

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