query performance issue
DB version is 11.2.0.3/2 node RAC
-Below insert is waiting on PX Deq: Parse Reply and no progress is made, session just waits
-25m rows being inserted from 125m
- all table stats are up to date
- no plan change in lower environment an this environment which is prod
- same row counts
INSERT /*+ APPEND */ INTO ASC_RPM_MISSING_TIMELINE (ITEM, DIFF_I
D, ITEM_PARENT, LOCATION, ZONE_NODE_TYPE, ZONE_ID, CUR_HIER_LEVE
L, TABLE_MISSING_FROM) WITH RFR_VW AS (SELECT /*+ PARALLEL(rfr 8
) */ RFR.DEPT, RFR.CLASS, RFR.SUBCLASS, RFR.ITEM, RFR.LOCATION,
- RFR.DIFF_ID, RFR.ZONE_ID, RFR.ZONE_NODE_TYPE, RFR.CUR_HIER_LEVEL
0