SQL Performance (MOSC)
MOSC Banner

how to fix sql query plan hash value

edited Jun 11, 2014 12:12AM in SQL Performance (MOSC) 6 commentsAnswered

Hi,

I have observed that one of production database query plan hash value changed from good execution plan to bad one.

I want to change the sql plan hash value to good one. How can I achieve that

PLAN_TABLE_OUTPUT

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

SQL_ID b6k5jmmz5qq4y

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

SELECT ENT_ID, ENT_NAME FROM ENTITY_MASTER,ENTITY_PRIVILEGE_MAPPING

WHERE ENT_ID = EPM_ENT_ID AND ENT_TYPE = 'CL' AND Ent_Status = 'E' AND

ENT_TEMPLET_CLIENT = 'Y' AND EPM_SEG_EQUITY = DECODE(:1,'Y','Y','N')

AND EPM_SEG_DERIVATIVES = DECODE(:2,'Y','Y','N') AND EPM_SEG_CF =

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