SQL Performance (MOSC)

MOSC Banner

SQL PLAN BASELINE

in SQL Performance (MOSC) 4 commentsAnswered ✓

Hello ,

I have a sql statement that I created a SQL baseline on and for a given plan hash value with ENABLED=NO .

My question is, why is the database still using the disabled plan when it should not.

SQL_HANDLE         PLAN_NAME            ENA ACC AUT FIX

------------------------- ------------------------------ --- --- --- ---

SQL_8d4734608f03c30c    SQL_PLAN_8ujtnc27h7hscb59c3dd9 YES YES YES YES

SQL_8d4734608f03c30c    SQL_PLAN_8ujtnc27h7hsc7c3bc589 NO YES YES NO ***DISABLED PLAN

Thanks,

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

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center