Database Tuning (MOSC)

MOSC Banner

Different execution plan for same SQL_ID

edited Jan 23, 2012 10:15PM in Database Tuning (MOSC) 13 commentsAnswered
Why do we see different hash value and different execution plan for same sql_id ? It is on 10204.

select * from table(dbms_xplan.display_awr('62cvdnk9bcwzq'))

PLAN_TABLE_OUTPUT
------------------------------------------------------------------------------------------------------------------------------------------------------
SQL_ID 62cvdnk9bcwzq
--------------------
select A.RATECD ,A.RATE ,A.RCATG  from CUST_RATE_SEGMENT A where ((((A.HOUSE=:b0 and A.CUST=:b1)
and A.SERVICE_GROUP=:b2) and A.STARTDATE=(select max(B.STARTDATE)  from CUST_RATE_SEGMENT B where
((((B.HOUSE=A.HOUSE and B.CUST=A.CUST) and B.SERVICE_GROUP=A.SERVICE_GROUP) and B.OUTLET=A.OUTLET)
and B.RATECD=A.RATECD))) and A.STATUS=:b3) order by A.RATECD

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