SQL Performance (MOSC)

MOSC Banner

Poor plan going from 10.2.0.4 to 11.2.0.2

edited May 23, 2013 4:08AM in SQL Performance (MOSC) 29 commentsAnswered
Hi,

We have upgraded a database from 10.2.0.4 to 11.2.0.2 and moved from Windows to REHL6.

The following query runs very good in 10g but really poor (it has infact never finished) in 11g.

SELECT UOM,USER_NAME,ZONE_NAME,SUM (CUSTOMERS_LEFT) AS CUSTOMERS_LEFT,SUM (TIME_UNTIL_DONE) AS TIME_UNTIL_DONE,MAX (UPD)FROM ( (SELECT UOM,USER_NAME,ZONE_NAME,NULL AS CUSTOMERS_LEFT,NULL AS TIME_UNTIL_DONE,1 AS UPDFROM USER.LDX_KPI_PICKINGWHERE FROM_DT >= :B3 AND TO_DT <= :B2 AND KPIRESOLUTION_KEY = :B1)

UNION(SELECT UOM,USER_NAME,ZONE_NAME,CUSTOMERS_LEFT,TIME_UNTIL_DONE

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