SQL> explain plan set statement_id='TTT' for 2 MERGE /*+ hash(rq) parallel(rq 8) full (rq) */ 3 INTO DWH_BILL_DET rq USING (SELECT /*+ use_hash(prd_rerate_chg_que) parallel(prd_rerate_chg_que 8) */ rated_que_rowid, 4 5 detail_rerate_flag_code, 6 rerate_sel_key, 7 rerate_adj_inv_code 8 FROM prd_rerate_chg_que PARTITION(SYS_P62532) 9 WHERE rerate_adj_inv_code >= 0 10 AND rerate_sel_key NOT IN 11 (SELECT /*+ unnest use_hash(prd_rerate_sel) parallel(prd_rerate_sel 8) */ rerate_sel_key 12 FROM prd_rerate_sel 13 WHERE status = 'Cancelled' 14 AND rerate_batch_key = 24)) rr 15 ON (rq.rowid = rr.rated_que_rowid and trunc(rq.call_start_dttm) between '01-JAN-11' and '31-JAN-11') 16 WHEN MATCHED THEN 17 UPDATE 18 SET rerate_flag_code = rr.detail_rerate_flag_code, 19 rerate_sel_key = rr.rerate_sel_key, 20 rerate_adj_inv_code = rr.rerate_adj_inv_code 21 WHEN NOT MATCHED THEN 22 INSERT (file_key) VALUES (NULL); Explained. SQL> set linesize 1000 SQL> set pagesize 1000 SQL> set trimspool on SQL> select * from table(sys.dbms_xplan.display('','TTT','ALL')); PLAN_TABLE_OUTPUT ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ Plan hash value: 1439365171 ---------------------------------------------------------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | Pstart| Pstop | TQ |IN-OUT| PQ Distrib | ---------------------------------------------------------------------------------------------------------------------------------------------------- | 0 | MERGE STATEMENT | | 1 | 481 | 3532 (1)| 00:00:43 | | | | | | | 1 | MERGE | DWH_BILL_DET | | | | | | | | | | | 2 | PX COORDINATOR | | | | | | | | | | | | 3 | PX SEND QC (RANDOM) | :TQ10001 | 1 | 487 | 3532 (1)| 00:00:43 | | | Q1,01 | P->S | QC (RAND) | | 4 | VIEW | | | | | | | | Q1,01 | PCWP | | |* 5 | HASH JOIN ANTI SNA | | 1 | 487 | 3532 (1)| 00:00:43 | | | Q1,01 | PCWP | | | 6 | NESTED LOOPS OUTER | | 1 | 471 | 3526 (1)| 00:00:43 | | | Q1,01 | PCWP | | | 7 | PX BLOCK ITERATOR | | 1 | 29 | 3526 (1)| 00:00:43 | 1 | 1 | Q1,01 | PCWC | | |* 8 | TABLE ACCESS FULL | PRD_RERATE_CHG_QUE | 1 | 29 | 3526 (1)| 00:00:43 | 1 | 1 | Q1,01 | PCWP | | |* 9 | TABLE ACCESS BY USER ROWID| DWH_BILL_DET | 1 | 442 | 1 (0)| 00:00:01 | ROWID | ROWID | Q1,01 | PCWP | | | 10 | BUFFER SORT | | | | | | | | Q1,01 | PCWC | | | 11 | PX RECEIVE | | 1 | 16 | 5 (0)| 00:00:01 | | | Q1,01 | PCWP | | | 12 | PX SEND BROADCAST | :TQ10000 | 1 | 16 | 5 (0)| 00:00:01 | | | | S->P | BROADCAST | |* 13 | TABLE ACCESS FULL | PRD_RERATE_SEL | 1 | 16 | 5 (0)| 00:00:01 | | | | | | ---------------------------------------------------------------------------------------------------------------------------------------------------- Query Block Name / Object Alias (identified by operation id): ------------------------------------------------------------- 1 - MRG$1 5 - SEL$658B16C2 8 - SEL$658B16C2 / PRD_RERATE_CHG_QUE@SEL$3 9 - SEL$658B16C2 / RQ@SEL$2 13 - SEL$658B16C2 / PRD_RERATE_SEL@SEL$4 Predicate Information (identified by operation id): --------------------------------------------------- 5 - access("RERATE_SEL_KEY"="RERATE_SEL_KEY") 8 - filter("RERATE_ADJ_INV_CODE">=0) 9 - filter(TRUNC(INTERNAL_FUNCTION("RQ"."CALL_START_DTTM"(+)))<='31-JAN-11' AND TRUNC(INTERNAL_FUNCTION("RQ"."CALL_START_DTTM"(+)))>='01-JAN-11') 13 - filter("RERATE_BATCH_KEY"=24 AND "STATUS"='Cancelled') Column Projection Information (identified by operation id): ----------------------------------------------------------- 1 - SYSDEF[4], SYSDEF[32720], SYSDEF[1], SYSDEF[96], SYSDEF[32720] 2 - (upd=2,3,4; cmp=2,3,4) "RQ".ROWID[ROWID,10], "RERATE_FLAG_CODE"[NUMBER,22], "RERATE_SEL_KEY"[NUMBER,22], "RERATE_ADJ_INV_CODE"[NUMBER,22], "RQ"."OUT_INTL_NBR_PFX_CODE"[NUMBER,22], "RQ"."RPT_CHG_TYPE_USG_BAND_IND"[NUMBER,22], "RQ"."RPT_CHG_TYPE_TIME_BAND_IND"[NUMBER,22], "RQ"."CHG_TYPE_USG_BAND_IND"[NUMBER,22], "RQ"."CHG_TYPE_TIME_BAND_IND"[NUMBER,22], "RQ"."RPT_USG_BAND_IND"[NUMBER,22], "RQ"."RPT_TIME_BAND_IND"[NUMBER,22], "RQ"."RPT_CHG_TYPE_IND"[NUMBER,22], "RQ"."USG_BAND_IND"[NUMBER,22], "RQ"."TIME_BAND_IND"[NUMBER,22], "RQ"."CHG_TYPE_IND"[NUMBER,22], "RQ"."RPT_IND"[NUMBER,22], "RQ"."CALL_IND"[NUMBER,22], "RQ"."CHG_AMT"[NUMBER,22], "RQ"."CHG_COMP_SCHM_CODE"[NUMBER,22], "RQ"."RATE_UNIT_FACTOR"[NUMBER,22], "RQ"."RATE_UNIT_CODE"[NUMBER,22], "RQ"."CCY_CODE"[NUMBER,22], "RQ"."CHG_RATE"[NUMBER,22], "RQ"."NOM_RATE_CCY_CODE"[NUMBER,22], "RQ"."NOM_RATE"[NUMBER,22], "RQ"."RATE_CODE"[NUMBER,22], "RQ"."RATE_TYPE_CODE"[NUMBER,22], "RQ"."CHG_DEST_CODE"[NUMBER,22], "RQ"."TAX_PCT"[NUMBER,22], "RQ"."TAX_AMT"[NUMBER,22], "RQ"."TAX_TYPE_CODE"[NUMBER,22], "RQ"."TIME_BAND_GRP_CODE"[NUMBER,22], "RQ"."TIME_BAND_CODE"[NUMBER,22], "RQ"."TIME_BAND_CHG_DUR"[NUMBER,22], "RQ"."CHG_DUR"[NUMBER,22], "RQ"."USG_BAND_CODE"[NUMBER,22], "RQ"."BANDED_CHG_USG"[NUMBER,22], "RQ"."CHG_USG"[NUMBER,22], "RQ"."CHG_USG_UNIT_CODE"[NUMBER,22], "RQ"."USG_COMP_SCHM_CODE"[NUMBER,22], "RQ"."CHG_ADJ_PCT"[NUMBER,22], "RQ"."CHG_TYPE_CODE"[NUMBER,22], "RQ"."TIER_CODE"[NUMBER,22], "RQ"."DIST_BAND_CODE"[NUMBER,22], "RQ"."CHG_CODE"[NUMBER,22], "RQ"."CALL_INV_DTTM"[DATE,7], "RQ"."CHG_KEY"[NUMBER,22], "RQ"."INV_TYPE_CODE"[NUMBER,22], "RQ"."INV_END_DTTM"[DATE,7], "RQ"."INV_CODE"[NUMBER,22], "RQ"."RPT_CODE"[NUMBER,22], "RQ"."CHG_PTY_CODE"[NUMBER,22], "RQ"."PLAN_CODE"[NUMBER,22], "RQ"."AGMT_CODE"[NUMBER,22], "RQ"."DIST_BAND_GRP_CODE"[NUMBER,22], "RQ"."CHG_POI_STATE_GRP_CODE"[NUMBER,22], "RQ"."CHG_POI_STATE_CODE"[NUMBER,22], "RQ"."CHG_POI_RGN_CODE"[NUMBER,22], "RQ"."CHG_POI_LOC_CODE"[NUMBER,22], "RQ"."CHG_POI_TRG_CODE"[NUMBER,22], "RQ"."CALL_STATUS_CODE"[NUMBER,22], "RQ"."CALL_TYPE_CODE"[NUMBER,22], "RQ"."RATING_GRP_CODE"[NUMBER,22], "RQ"."EVENT_CASE_CODE"[NUMBER,22], "RQ"."OUT_INTL_DEST_CODE"[NUMBER,22], "RQ"."OUT_INTL_NBR_PFX_GRP_CODE"[NUMBER,22], "RQ"."OUT_INTL_DEST_METHOD_CODE"[NUMBER,22], "RQ"."OUT_INTL_TRAF_TYPE_CODE"[NUMBER,22], "RQ"."OUT_INTL_TRAF_DF_CODE"[NUMBER,22], "RQ"."IN_INTL_DEST_CODE"[NUMBER,22], "RQ"."IN_INTL_NBR_PFX_GRP_CODE"[NUMBER,22], "RQ"."IN_INTL_DEST_METHOD_CODE"[NUMBER,22], "RQ"."IN_INTL_TRAF_TYPE_CODE"[NUMBER,22], "RQ"."IN_INTL_TRAF_DF_CODE"[NUMBER,22], "RQ"."B_PTY_DEST_CODE"[NUMBER,22], "RQ"."B_PTY_TIER_CODE"[NUMBER,22], "RQ"."B_PTY_CTRY_CODE"[NUMBER,22], "RQ"."B_PTY_LOC_TYPE_CODE"[NUMBER,22], "RQ"."B_PTY_LOC_CODE"[NUMBER,22], "RQ"."B_PTY_SUB_SVC_CODE"[NUMBER,22], "RQ"."B_PTY_SVC_CODE"[NUMBER,22], "RQ"."B_PTY_CRR_CODE"[NUMBER,22], "RQ"."B_PTY_NBR_PFX_CODE"[NUMBER,22], "RQ"."A_PTY_TIER_CODE"[NUMBER,22], "RQ"."A_PTY_CTRY_CODE"[NUMBER,22], "RQ"."A_PTY_LOC_CODE"[NUMBER,22], "RQ"."A_PTY_SUB_SVC_CODE"[NUMBER,22], "RQ"."A_PTY_SVC_CODE"[NUMBER,22], "RQ"."A_PTY_CRR_CODE"[NUMBER,22], "RQ"."A_PTY_NBR_PFX_CODE"[NUMBER,22], "RQ"."B_PTY_NON_RN_NBR"[VARCHAR2,24], "RQ"."A_PTY_NON_RN_NBR"[VARCHAR2,24], "RQ"."B_PTY_ACS_NBR_CAT_CODE"[NUMBER,22], "RQ"."B_PTY_ACS_NBR_CRR_CODE"[NUMBER,22], "RQ"."NORM_B_PTY_NBR"[VARCHAR2,24], "RQ"."B_PTY_NBR_TYPE_CODE"[NUMBER,22], "RQ"."B_PTY_NBR_NORM_CODE"[NUMBER,22], "RQ"."NORM_A_PTY_NBR"[VARCHAR2,24], "RQ"."A_PTY_NBR_TYPE_CODE"[NUMBER,22], "RQ"."A_PTY_NBR_NORM_CODE"[NUMBER,22], "RQ"."OUT_TRG_LOC_CODE"[NUMBER,22], "RQ"."OUT_TRG_CRR_CODE"[NUMBER,22], "RQ"."OUT_TRG_TYPE_CODE"[NUMBER,22], "RQ"."OUT_TRG_CODE"[NUMBER,22], "RQ"."IN_TRG_LOC_CODE"[NUMBER,22], "RQ"."IN_TRG_CRR_CODE"[NUMBER,22], "RQ"."IN_TRG_TYPE_CODE"[NUMBER,22], "RQ"."IN_TRG_CODE"[NUMBER,22], "RQ"."TRAF_CLASS_CODE"[NUMBER,22], "RQ"."TRAF_TYPE_CODE"[NUMBER,22], "RQ"."RTE_PATH_CODE"[NUMBER,22], "RQ"."REC_TYPE_CODE"[NUMBER,22], "RQ"."SWI_LOC_CODE" 3 - (#keys=0) "RQ".ROWID[ROWID,10], "RERATE_FLAG_CODE"[NUMBER,22], "RERATE_SEL_KEY"[NUMBER,22], "RERATE_ADJ_INV_CODE"[NUMBER,22], "RQ"."OUT_INTL_NBR_PFX_CODE"[NUMBER,22], "RQ"."RPT_CHG_TYPE_USG_BAND_IND"[NUMBER,22], "RQ"."RPT_CHG_TYPE_TIME_BAND_IND"[NUMBER,22], "RQ"."CHG_TYPE_USG_BAND_IND"[NUMBER,22], "RQ"."CHG_TYPE_TIME_BAND_IND"[NUMBER,22], "RQ"."RPT_USG_BAND_IND"[NUMBER,22], "RQ"."RPT_TIME_BAND_IND"[NUMBER,22], "RQ"."RPT_CHG_TYPE_IND"[NUMBER,22], "RQ"."USG_BAND_IND"[NUMBER,22], "RQ"."TIME_BAND_IND"[NUMBER,22], "RQ"."CHG_TYPE_IND"[NUMBER,22], "RQ"."RPT_IND"[NUMBER,22], "RQ"."CALL_IND"[NUMBER,22], "RQ"."CHG_AMT"[NUMBER,22], "RQ"."CHG_COMP_SCHM_CODE"[NUMBER,22], "RQ"."RATE_UNIT_FACTOR"[NUMBER,22], "RQ"."RATE_UNIT_CODE"[NUMBER,22], "RQ"."CCY_CODE"[NUMBER,22], "RQ"."CHG_RATE"[NUMBER,22], "RQ"."NOM_RATE_CCY_CODE"[NUMBER,22], "RQ"."NOM_RATE"[NUMBER,22], "RQ"."RATE_CODE"[NUMBER,22], "RQ"."RATE_TYPE_CODE"[NUMBER,22], "RQ"."CHG_DEST_CODE"[NUMBER,22], "RQ"."TAX_PCT"[NUMBER,22], "RQ"."TAX_AMT"[NUMBER,22], "RQ"."TAX_TYPE_CODE"[NUMBER,22], "RQ"."TIME_BAND_GRP_CODE"[NUMBER,22], "RQ"."TIME_BAND_CODE"[NUMBER,22], "RQ"."TIME_BAND_CHG_DUR"[NUMBER,22], "RQ"."CHG_DUR"[NUMBER,22], "RQ"."USG_BAND_CODE"[NUMBER,22], "RQ"."BANDED_CHG_USG"[NUMBER,22], "RQ"."CHG_USG"[NUMBER,22], "RQ"."CHG_USG_UNIT_CODE"[NUMBER,22], "RQ"."USG_COMP_SCHM_CODE"[NUMBER,22], "RQ"."CHG_ADJ_PCT"[NUMBER,22], "RQ"."CHG_TYPE_CODE"[NUMBER,22], "RQ"."TIER_CODE"[NUMBER,22], "RQ"."DIST_BAND_CODE"[NUMBER,22], "RQ"."CHG_CODE"[NUMBER,22], "RQ"."CALL_INV_DTTM"[DATE,7], "RQ"."CHG_KEY"[NUMBER,22], "RQ"."INV_TYPE_CODE"[NUMBER,22], "RQ"."INV_END_DTTM"[DATE,7], "RQ"."INV_CODE"[NUMBER,22], "RQ"."RPT_CODE"[NUMBER,22], "RQ"."CHG_PTY_CODE"[NUMBER,22], "RQ"."PLAN_CODE"[NUMBER,22], "RQ"."AGMT_CODE"[NUMBER,22], "RQ"."DIST_BAND_GRP_CODE"[NUMBER,22], "RQ"."CHG_POI_STATE_GRP_CODE"[NUMBER,22], "RQ"."CHG_POI_STATE_CODE"[NUMBER,22], "RQ"."CHG_POI_RGN_CODE"[NUMBER,22], "RQ"."CHG_POI_LOC_CODE"[NUMBER,22], "RQ"."CHG_POI_TRG_CODE"[NUMBER,22], "RQ"."CALL_STATUS_CODE"[NUMBER,22], "RQ"."CALL_TYPE_CODE"[NUMBER,22], "RQ"."RATING_GRP_CODE"[NUMBER,22], "RQ"."EVENT_CASE_CODE"[NUMBER,22], "RQ"."OUT_INTL_DEST_CODE"[NUMBER,22], "RQ"."OUT_INTL_NBR_PFX_GRP_CODE"[NUMBER,22], "RQ"."OUT_INTL_DEST_METHOD_CODE"[NUMBER,22], "RQ"."OUT_INTL_TRAF_TYPE_CODE"[NUMBER,22], "RQ"."OUT_INTL_TRAF_DF_CODE"[NUMBER,22], "RQ"."IN_INTL_DEST_CODE"[NUMBER,22], "RQ"."IN_INTL_NBR_PFX_GRP_CODE"[NUMBER,22], "RQ"."IN_INTL_DEST_METHOD_CODE"[NUMBER,22], "RQ"."IN_INTL_TRAF_TYPE_CODE"[NUMBER,22], "RQ"."IN_INTL_TRAF_DF_CODE"[NUMBER,22], "RQ"."B_PTY_DEST_CODE"[NUMBER,22], "RQ"."B_PTY_TIER_CODE"[NUMBER,22], "RQ"."B_PTY_CTRY_CODE"[NUMBER,22], "RQ"."B_PTY_LOC_TYPE_CODE"[NUMBER,22], "RQ"."B_PTY_LOC_CODE"[NUMBER,22], "RQ"."B_PTY_SUB_SVC_CODE"[NUMBER,22], "RQ"."B_PTY_SVC_CODE"[NUMBER,22], "RQ"."B_PTY_CRR_CODE"[NUMBER,22], "RQ"."B_PTY_NBR_PFX_CODE"[NUMBER,22], "RQ"."A_PTY_TIER_CODE"[NUMBER,22], "RQ"."A_PTY_CTRY_CODE"[NUMBER,22], "RQ"."A_PTY_LOC_CODE"[NUMBER,22], "RQ"."A_PTY_SUB_SVC_CODE"[NUMBER,22], "RQ"."A_PTY_SVC_CODE"[NUMBER,22], "RQ"."A_PTY_CRR_CODE"[NUMBER,22], "RQ"."A_PTY_NBR_PFX_CODE"[NUMBER,22], "RQ"."B_PTY_NON_RN_NBR"[VARCHAR2,24], "RQ"."A_PTY_NON_RN_NBR"[VARCHAR2,24], "RQ"."B_PTY_ACS_NBR_CAT_CODE"[NUMBER,22], "RQ"."B_PTY_ACS_NBR_CRR_CODE"[NUMBER,22], "RQ"."NORM_B_PTY_NBR"[VARCHAR2,24], "RQ"."B_PTY_NBR_TYPE_CODE"[NUMBER,22], "RQ"."B_PTY_NBR_NORM_CODE"[NUMBER,22], "RQ"."NORM_A_PTY_NBR"[VARCHAR2,24], "RQ"."A_PTY_NBR_TYPE_CODE"[NUMBER,22], "RQ"."A_PTY_NBR_NORM_CODE"[NUMBER,22], "RQ"."OUT_TRG_LOC_CODE"[NUMBER,22], "RQ"."OUT_TRG_CRR_CODE"[NUMBER,22], "RQ"."OUT_TRG_TYPE_CODE"[NUMBER,22], "RQ"."OUT_TRG_CODE"[NUMBER,22], "RQ"."IN_TRG_LOC_CODE"[NUMBER,22], "RQ"."IN_TRG_CRR_CODE"[NUMBER,22], "RQ"."IN_TRG_TYPE_CODE"[NUMBER,22], "RQ"."IN_TRG_CODE"[NUMBER,22], "RQ"."TRAF_CLASS_CODE"[NUMBER,22], "RQ"."TRAF_TYPE_CODE"[NUMBER,22], "RQ"."RTE_PATH_CODE"[NUMBER,22], "RQ"."REC_TYPE_CODE"[NUMBER,22], "RQ"."SWI_LOC_CODE"[NUMBER,22], "RQ"."SWI_CRR_CODE" 4 - "RR"."DETAIL_RERATE_FLAG_CODE"[NUMBER,22], "RR"."RERATE_SEL_KEY"[NUMBER,22], "RR"."RERATE_ADJ_INV_CODE"[NUMBER,22] 5 - (#keys=1) "RERATE_SEL_KEY"[NUMBER,22], "RERATE_SEL_KEY"[NUMBER,22], "RQ"."OUT_INTL_NBR_PFX_CODE"[NUMBER,22], "RERATE_ADJ_INV_CODE"[NUMBER,22], "DETAIL_RERATE_FLAG_CODE"[NUMBER,22], "RATED_QUE_ROWID"[ROWID,10], "RQ".ROWID[ROWID,10], "RQ"."FILE_KEY"[NUMBER,22], "RQ"."REC_KEY"[NUMBER,22], "RQ"."ORIG_REC_KEY"[NUMBER,22], "RQ"."SWI_ID"[VARCHAR2,12], "RQ"."REC_TYPE_ID"[VARCHAR2,15], "RQ"."DUR_SPAN_ID"[NUMBER,22], "RQ"."CALL_START_DTTM"[DATE,7], "RQ"."PRE_CONV_DUR"[NUMBER,22], "RQ"."CONV_DUR"[NUMBER,22], "RQ"."A_PTY_NBR"[VARCHAR2,24], "RQ"."A_PTY_NBR_TYPE_ID"[VARCHAR2,3], "RQ"."A_PTY_CELL_ID"[VARCHAR2,16], "RQ"."A_PTY_IMSI"[VARCHAR2,15], "RQ"."A_PTY_MSRN"[VARCHAR2,24], "RQ"."B_PTY_NBR"[VARCHAR2,24], "RQ"."B_PTY_NBR_TYPE_ID"[VARCHAR2,3], "RQ"."B_PTY_CELL_ID"[VARCHAR2,16], "RQ"."B_PTY_IMSI"[VARCHAR2,15], "RQ"."B_PTY_MSRN"[VARCHAR2,24], "RQ"."IN_TRG_ID"[VARCHAR2,16], "RQ"."OUT_TRG_ID"[VARCHAR2,16], "RQ"."CALL_STATUS_ID"[NUMBER,22], "RQ"."SUPP_SVC_ID"[NUMBER,22], "RQ"."PROV_CHG_AMT"[NUMBER,22], "RQ"."GEN_FIELD_1"[VARCHAR2,1000], "RQ"."GEN_FIELD_2"[VARCHAR2,1000], "RQ"."GEN_FIELD_3"[VARCHAR2,1000], "RQ"."GEN_FIELD_4"[VARCHAR2,1000], "RQ"."GEN_FIELD_5"[VARCHAR2,1000], "RQ"."PARTITION_KEY"[NUMBER,22], "RQ"."PROC_DTTM"[DATE,7], "RQ"."RERATE_SEL_KEY"[NUMBER,22], "RQ"."MERGE_FILE_KEY"[NUMBER,22], "RQ"."MERGE_REC_KEY"[NUMBER,22], "RQ"."MERGE_FLAG_CODE"[NUMBER,22], "RQ"."RTE_VARIATION_CODE"[NUMBER,22], "RQ"."SWI_CODE"[NUMBER,22], "RQ"."SWI_TYPE_CODE"[NUMBER,22], "RQ"."SWI_CRR_CODE"[NUMBER,22], "RQ"."SWI_LOC_CODE"[NUMBER,22], "RQ"."REC_TYPE_CODE"[NUMBER,22], "RQ"."RTE_PATH_CODE"[NUMBER,22], "RQ"."TRAF_TYPE_CODE"[NUMBER,22], "RQ"."TRAF_CLASS_CODE"[NUMBER,22], "RQ"."IN_TRG_CODE"[NUMBER,22], "RQ"."IN_TRG_TYPE_CODE"[NUMBER,22], "RQ"."IN_TRG_CRR_CODE"[NUMBER,22], "RQ"."IN_TRG_LOC_CODE"[NUMBER,22], "RQ"."OUT_TRG_CODE"[NUMBER,22], "RQ"."OUT_TRG_TYPE_CODE"[NUMBER,22], "RQ"."OUT_TRG_CRR_CODE"[NUMBER,22], "RQ"."OUT_TRG_LOC_CODE"[NUMBER,22], "RQ"."A_PTY_NBR_NORM_CODE"[NUMBER,22], "RQ"."A_PTY_NBR_TYPE_CODE"[NUMBER,22], "RQ"."NORM_A_PTY_NBR"[VARCHAR2,24], "RQ"."B_PTY_NBR_NORM_CODE"[NUMBER,22], "RQ"."B_PTY_NBR_TYPE_CODE"[NUMBER,22], "RQ"."NORM_B_PTY_NBR"[VARCHAR2,24], "RQ"."B_PTY_ACS_NBR_CRR_CODE"[NUMBER,22], "RQ"."B_PTY_ACS_NBR_CAT_CODE"[NUMBER,22], "RQ"."A_PTY_NON_RN_NBR"[VARCHAR2,24], "RQ"."B_PTY_NON_RN_NBR"[VARCHAR2,24], "RQ"."A_PTY_NBR_PFX_CODE"[NUMBER,22], "RQ"."A_PTY_CRR_CODE"[NUMBER,22], "RQ"."A_PTY_SVC_CODE"[NUMBER,22], "RQ"."A_PTY_SUB_SVC_CODE"[NUMBER,22], "RQ"."A_PTY_LOC_CODE"[NUMBER,22], "RQ"."A_PTY_CTRY_CODE"[NUMBER,22], "RQ"."A_PTY_TIER_CODE"[NUMBER,22], "RQ"."B_PTY_NBR_PFX_CODE"[NUMBER,22], "RQ"."B_PTY_CRR_CODE"[NUMBER,22], "RQ"."B_PTY_SVC_CODE"[NUMBER,22], "RQ"."B_PTY_SUB_SVC_CODE"[NUMBER,22], "RQ"."B_PTY_LOC_CODE"[NUMBER,22], "RQ"."B_PTY_LOC_TYPE_CODE"[NUMBER,22], "RQ"."B_PTY_CTRY_CODE"[NUMBER,22], "RQ"."B_PTY_TIER_CODE"[NUMBER,22], "RQ"."B_PTY_DEST_CODE"[NUMBER,22], "RQ"."IN_INTL_TRAF_DF_CODE"[NUMBER,22], "RQ"."IN_INTL_TRAF_TYPE_CODE"[NUMBER,22], "RQ"."IN_INTL_DEST_METHOD_CODE"[NUMBER,22], "RQ"."IN_INTL_NBR_PFX_GRP_CODE"[NUMBER,22], "RQ"."IN_INTL_DEST_CODE"[NUMBER,22], "RQ"."OUT_INTL_TRAF_DF_CODE"[NUMBER,22], "RQ"."OUT_INTL_TRAF_TYPE_CODE"[NUMBER,22], "RQ"."OUT_INTL_DEST_METHOD_CODE"[NUMBER,22], "RQ"."OUT_INTL_NBR_PFX_GRP_CODE"[NUMBER,22], "RQ"."OUT_INTL_DEST_CODE"[NUMBER,22], "RQ"."RERATE_FLAG_CODE"[NUMBER,22], "RQ"."EVENT_CASE_CODE"[NUMBER,22], "RQ"."RATING_GRP_CODE"[NUMBER,22], "RQ"."CALL_TYPE_CODE"[NUMBER,22], "RQ"."CALL_STATUS_CODE"[NUMBER,22], "RQ"."CHG_POI_TRG_CODE"[NUMBER,22], "RQ"."CHG_POI_LOC_CODE"[NUMBER,22], "RQ"."CHG_POI_RGN_CODE"[NUMBER,22], "RQ"."CHG_POI_STATE_CODE"[NUMBER,22], "RQ"."CHG_POI_STATE_GRP_CODE"[NUMBER,22], "RQ"."DIST_BAND_GRP_CODE"[NUMBER,22], "RQ"."AGMT_CODE"[NUMBER,22], "RQ"."PLAN_CODE"[NUMBER,22], "RQ"."CHG_PTY_CODE"[NUMBER,22], "RQ"."RPT_CODE"[NUMBER,22], "RQ"."INV_CODE"[NUMBER,22], "RQ"."INV_END_DTTM"[DATE,7], "RQ"."INV_TYPE_CODE"[NUMBER,22], "RQ"."CHG_KEY"[NUMBER,22], "RQ"."CALL_INV_DTTM" 6 - (#keys=0) "RERATE_SEL_KEY"[NUMBER,22], "RERATE_ADJ_INV_CODE"[NUMBER,22], "DETAIL_RERATE_FLAG_CODE"[NUMBER,22], "RATED_QUE_ROWID"[ROWID,10], "RQ".ROWID[ROWID,10], "RQ"."FILE_KEY"[NUMBER,22], "RQ"."REC_KEY"[NUMBER,22], "RQ"."ORIG_REC_KEY"[NUMBER,22], "RQ"."SWI_ID"[VARCHAR2,12], "RQ"."REC_TYPE_ID"[VARCHAR2,15], "RQ"."DUR_SPAN_ID"[NUMBER,22], "RQ"."CALL_START_DTTM"[DATE,7], "RQ"."PRE_CONV_DUR"[NUMBER,22], "RQ"."CONV_DUR"[NUMBER,22], "RQ"."A_PTY_NBR"[VARCHAR2,24], "RQ"."A_PTY_NBR_TYPE_ID"[VARCHAR2,3], "RQ"."A_PTY_CELL_ID"[VARCHAR2,16], "RQ"."A_PTY_IMSI"[VARCHAR2,15], "RQ"."A_PTY_MSRN"[VARCHAR2,24], "RQ"."B_PTY_NBR"[VARCHAR2,24], "RQ"."B_PTY_NBR_TYPE_ID"[VARCHAR2,3], "RQ"."B_PTY_CELL_ID"[VARCHAR2,16], "RQ"."B_PTY_IMSI"[VARCHAR2,15], "RQ"."B_PTY_MSRN"[VARCHAR2,24], "RQ"."IN_TRG_ID"[VARCHAR2,16], "RQ"."OUT_TRG_ID"[VARCHAR2,16], "RQ"."CALL_STATUS_ID"[NUMBER,22], "RQ"."SUPP_SVC_ID"[NUMBER,22], "RQ"."PROV_CHG_AMT"[NUMBER,22], "RQ"."GEN_FIELD_1"[VARCHAR2,1000], "RQ"."GEN_FIELD_2"[VARCHAR2,1000], "RQ"."GEN_FIELD_3"[VARCHAR2,1000], "RQ"."GEN_FIELD_4"[VARCHAR2,1000], "RQ"."GEN_FIELD_5"[VARCHAR2,1000], "RQ"."PARTITION_KEY"[NUMBER,22], "RQ"."PROC_DTTM"[DATE,7], "RQ"."RERATE_SEL_KEY"[NUMBER,22], "RQ"."MERGE_FILE_KEY"[NUMBER,22], "RQ"."MERGE_REC_KEY"[NUMBER,22], "RQ"."MERGE_FLAG_CODE"[NUMBER,22], "RQ"."RTE_VARIATION_CODE"[NUMBER,22], "RQ"."SWI_CODE"[NUMBER,22], "RQ"."SWI_TYPE_CODE"[NUMBER,22], "RQ"."SWI_CRR_CODE"[NUMBER,22], "RQ"."SWI_LOC_CODE"[NUMBER,22], "RQ"."REC_TYPE_CODE"[NUMBER,22], "RQ"."RTE_PATH_CODE"[NUMBER,22], "RQ"."TRAF_TYPE_CODE"[NUMBER,22], "RQ"."TRAF_CLASS_CODE"[NUMBER,22], "RQ"."IN_TRG_CODE"[NUMBER,22], "RQ"."IN_TRG_TYPE_CODE"[NUMBER,22], "RQ"."IN_TRG_CRR_CODE"[NUMBER,22], "RQ"."IN_TRG_LOC_CODE"[NUMBER,22], "RQ"."OUT_TRG_CODE"[NUMBER,22], "RQ"."OUT_TRG_TYPE_CODE"[NUMBER,22], "RQ"."OUT_TRG_CRR_CODE"[NUMBER,22], "RQ"."OUT_TRG_LOC_CODE"[NUMBER,22], "RQ"."A_PTY_NBR_NORM_CODE"[NUMBER,22], "RQ"."A_PTY_NBR_TYPE_CODE"[NUMBER,22], "RQ"."NORM_A_PTY_NBR"[VARCHAR2,24], "RQ"."B_PTY_NBR_NORM_CODE"[NUMBER,22], "RQ"."B_PTY_NBR_TYPE_CODE"[NUMBER,22], "RQ"."NORM_B_PTY_NBR"[VARCHAR2,24], "RQ"."B_PTY_ACS_NBR_CRR_CODE"[NUMBER,22], "RQ"."B_PTY_ACS_NBR_CAT_CODE"[NUMBER,22], "RQ"."A_PTY_NON_RN_NBR"[VARCHAR2,24], "RQ"."B_PTY_NON_RN_NBR"[VARCHAR2,24], "RQ"."A_PTY_NBR_PFX_CODE"[NUMBER,22], "RQ"."A_PTY_CRR_CODE"[NUMBER,22], "RQ"."A_PTY_SVC_CODE"[NUMBER,22], "RQ"."A_PTY_SUB_SVC_CODE"[NUMBER,22], "RQ"."A_PTY_LOC_CODE"[NUMBER,22], "RQ"."A_PTY_CTRY_CODE"[NUMBER,22], "RQ"."A_PTY_TIER_CODE"[NUMBER,22], "RQ"."B_PTY_NBR_PFX_CODE"[NUMBER,22], "RQ"."B_PTY_CRR_CODE"[NUMBER,22], "RQ"."B_PTY_SVC_CODE"[NUMBER,22], "RQ"."B_PTY_SUB_SVC_CODE"[NUMBER,22], "RQ"."B_PTY_LOC_CODE"[NUMBER,22], "RQ"."B_PTY_LOC_TYPE_CODE"[NUMBER,22], "RQ"."B_PTY_CTRY_CODE"[NUMBER,22], "RQ"."B_PTY_TIER_CODE"[NUMBER,22], "RQ"."B_PTY_DEST_CODE"[NUMBER,22], "RQ"."IN_INTL_TRAF_DF_CODE"[NUMBER,22], "RQ"."IN_INTL_TRAF_TYPE_CODE"[NUMBER,22], "RQ"."IN_INTL_DEST_METHOD_CODE"[NUMBER,22], "RQ"."IN_INTL_NBR_PFX_GRP_CODE"[NUMBER,22], "RQ"."IN_INTL_DEST_CODE"[NUMBER,22], "RQ"."OUT_INTL_TRAF_DF_CODE"[NUMBER,22], "RQ"."OUT_INTL_TRAF_TYPE_CODE"[NUMBER,22], "RQ"."OUT_INTL_DEST_METHOD_CODE"[NUMBER,22], "RQ"."OUT_INTL_NBR_PFX_GRP_CODE"[NUMBER,22], "RQ"."OUT_INTL_DEST_CODE"[NUMBER,22], "RQ"."RERATE_FLAG_CODE"[NUMBER,22], "RQ"."EVENT_CASE_CODE"[NUMBER,22], "RQ"."RATING_GRP_CODE"[NUMBER,22], "RQ"."CALL_TYPE_CODE"[NUMBER,22], "RQ"."CALL_STATUS_CODE"[NUMBER,22], "RQ"."CHG_POI_TRG_CODE"[NUMBER,22], "RQ"."CHG_POI_LOC_CODE"[NUMBER,22], "RQ"."CHG_POI_RGN_CODE"[NUMBER,22], "RQ"."CHG_POI_STATE_CODE"[NUMBER,22], "RQ"."CHG_POI_STATE_GRP_CODE"[NUMBER,22], "RQ"."DIST_BAND_GRP_CODE"[NUMBER,22], "RQ"."AGMT_CODE"[NUMBER,22], "RQ"."PLAN_CODE"[NUMBER,22], "RQ"."CHG_PTY_CODE"[NUMBER,22], "RQ"."RPT_CODE"[NUMBER,22], "RQ"."INV_CODE"[NUMBER,22], "RQ"."INV_END_DTTM"[DATE,7], "RQ"."INV_TYPE_CODE"[NUMBER,22], "RQ"."CHG_KEY"[NUMBER,22], "RQ"."CALL_INV_DTTM"[DATE,7], "RQ"."CHG_CODE"[NUMBER,22], "RQ"."DIST_BAND_CODE" 7 - "RERATE_SEL_KEY"[NUMBER,22], "RERATE_ADJ_INV_CODE"[NUMBER,22], "DETAIL_RERATE_FLAG_CODE"[NUMBER,22], "RATED_QUE_ROWID"[ROWID,10] 8 - "RERATE_SEL_KEY"[NUMBER,22], "RERATE_ADJ_INV_CODE"[NUMBER,22], "DETAIL_RERATE_FLAG_CODE"[NUMBER,22], "RATED_QUE_ROWID"[ROWID,10] 9 - "RQ".ROWID[ROWID,10], "RQ"."FILE_KEY"[NUMBER,22], "RQ"."REC_KEY"[NUMBER,22], "RQ"."ORIG_REC_KEY"[NUMBER,22], "RQ"."SWI_ID"[VARCHAR2,12], "RQ"."REC_TYPE_ID"[VARCHAR2,15], "RQ"."DUR_SPAN_ID"[NUMBER,22], "RQ"."CALL_START_DTTM"[DATE,7], "RQ"."PRE_CONV_DUR"[NUMBER,22], "RQ"."CONV_DUR"[NUMBER,22], "RQ"."A_PTY_NBR"[VARCHAR2,24], "RQ"."A_PTY_NBR_TYPE_ID"[VARCHAR2,3], "RQ"."A_PTY_CELL_ID"[VARCHAR2,16], "RQ"."A_PTY_IMSI"[VARCHAR2,15], "RQ"."A_PTY_MSRN"[VARCHAR2,24], "RQ"."B_PTY_NBR"[VARCHAR2,24], "RQ"."B_PTY_NBR_TYPE_ID"[VARCHAR2,3], "RQ"."B_PTY_CELL_ID"[VARCHAR2,16], "RQ"."B_PTY_IMSI"[VARCHAR2,15], "RQ"."B_PTY_MSRN"[VARCHAR2,24], "RQ"."IN_TRG_ID"[VARCHAR2,16], "RQ"."OUT_TRG_ID"[VARCHAR2,16], "RQ"."CALL_STATUS_ID"[NUMBER,22], "RQ"."SUPP_SVC_ID"[NUMBER,22], "RQ"."PROV_CHG_AMT"[NUMBER,22], "RQ"."GEN_FIELD_1"[VARCHAR2,1000], "RQ"."GEN_FIELD_2"[VARCHAR2,1000], "RQ"."GEN_FIELD_3"[VARCHAR2,1000], "RQ"."GEN_FIELD_4"[VARCHAR2,1000], "RQ"."GEN_FIELD_5"[VARCHAR2,1000], "RQ"."PARTITION_KEY"[NUMBER,22], "RQ"."PROC_DTTM"[DATE,7], "RQ"."RERATE_SEL_KEY"[NUMBER,22], "RQ"."MERGE_FILE_KEY"[NUMBER,22], "RQ"."MERGE_REC_KEY"[NUMBER,22], "RQ"."MERGE_FLAG_CODE"[NUMBER,22], "RQ"."RTE_VARIATION_CODE"[NUMBER,22], "RQ"."SWI_CODE"[NUMBER,22], "RQ"."SWI_TYPE_CODE"[NUMBER,22], "RQ"."SWI_CRR_CODE"[NUMBER,22], "RQ"."SWI_LOC_CODE"[NUMBER,22], "RQ"."REC_TYPE_CODE"[NUMBER,22], "RQ"."RTE_PATH_CODE"[NUMBER,22], "RQ"."TRAF_TYPE_CODE"[NUMBER,22], "RQ"."TRAF_CLASS_CODE"[NUMBER,22], "RQ"."IN_TRG_CODE"[NUMBER,22], "RQ"."IN_TRG_TYPE_CODE"[NUMBER,22], "RQ"."IN_TRG_CRR_CODE"[NUMBER,22], "RQ"."IN_TRG_LOC_CODE"[NUMBER,22], "RQ"."OUT_TRG_CODE"[NUMBER,22], "RQ"."OUT_TRG_TYPE_CODE"[NUMBER,22], "RQ"."OUT_TRG_CRR_CODE"[NUMBER,22], "RQ"."OUT_TRG_LOC_CODE"[NUMBER,22], "RQ"."A_PTY_NBR_NORM_CODE"[NUMBER,22], "RQ"."A_PTY_NBR_TYPE_CODE"[NUMBER,22], "RQ"."NORM_A_PTY_NBR"[VARCHAR2,24], "RQ"."B_PTY_NBR_NORM_CODE"[NUMBER,22], "RQ"."B_PTY_NBR_TYPE_CODE"[NUMBER,22], "RQ"."NORM_B_PTY_NBR"[VARCHAR2,24], "RQ"."B_PTY_ACS_NBR_CRR_CODE"[NUMBER,22], "RQ"."B_PTY_ACS_NBR_CAT_CODE"[NUMBER,22], "RQ"."A_PTY_NON_RN_NBR"[VARCHAR2,24], "RQ"."B_PTY_NON_RN_NBR"[VARCHAR2,24], "RQ"."A_PTY_NBR_PFX_CODE"[NUMBER,22], "RQ"."A_PTY_CRR_CODE"[NUMBER,22], "RQ"."A_PTY_SVC_CODE"[NUMBER,22], "RQ"."A_PTY_SUB_SVC_CODE"[NUMBER,22], "RQ"."A_PTY_LOC_CODE"[NUMBER,22], "RQ"."A_PTY_CTRY_CODE"[NUMBER,22], "RQ"."A_PTY_TIER_CODE"[NUMBER,22], "RQ"."B_PTY_NBR_PFX_CODE"[NUMBER,22], "RQ"."B_PTY_CRR_CODE"[NUMBER,22], "RQ"."B_PTY_SVC_CODE"[NUMBER,22], "RQ"."B_PTY_SUB_SVC_CODE"[NUMBER,22], "RQ"."B_PTY_LOC_CODE"[NUMBER,22], "RQ"."B_PTY_LOC_TYPE_CODE"[NUMBER,22], "RQ"."B_PTY_CTRY_CODE"[NUMBER,22], "RQ"."B_PTY_TIER_CODE"[NUMBER,22], "RQ"."B_PTY_DEST_CODE"[NUMBER,22], "RQ"."IN_INTL_TRAF_DF_CODE"[NUMBER,22], "RQ"."IN_INTL_TRAF_TYPE_CODE"[NUMBER,22], "RQ"."IN_INTL_DEST_METHOD_CODE"[NUMBER,22], "RQ"."IN_INTL_NBR_PFX_GRP_CODE"[NUMBER,22], "RQ"."IN_INTL_DEST_CODE"[NUMBER,22], "RQ"."OUT_INTL_TRAF_DF_CODE"[NUMBER,22], "RQ"."OUT_INTL_TRAF_TYPE_CODE"[NUMBER,22], "RQ"."OUT_INTL_DEST_METHOD_CODE"[NUMBER,22], "RQ"."OUT_INTL_NBR_PFX_GRP_CODE"[NUMBER,22], "RQ"."OUT_INTL_DEST_CODE"[NUMBER,22], "RQ"."RERATE_FLAG_CODE"[NUMBER,22], "RQ"."EVENT_CASE_CODE"[NUMBER,22], "RQ"."RATING_GRP_CODE"[NUMBER,22], "RQ"."CALL_TYPE_CODE"[NUMBER,22], "RQ"."CALL_STATUS_CODE"[NUMBER,22], "RQ"."CHG_POI_TRG_CODE"[NUMBER,22], "RQ"."CHG_POI_LOC_CODE"[NUMBER,22], "RQ"."CHG_POI_RGN_CODE"[NUMBER,22], "RQ"."CHG_POI_STATE_CODE"[NUMBER,22], "RQ"."CHG_POI_STATE_GRP_CODE"[NUMBER,22], "RQ"."DIST_BAND_GRP_CODE"[NUMBER,22], "RQ"."AGMT_CODE"[NUMBER,22], "RQ"."PLAN_CODE"[NUMBER,22], "RQ"."CHG_PTY_CODE"[NUMBER,22], "RQ"."RPT_CODE"[NUMBER,22], "RQ"."INV_CODE"[NUMBER,22], "RQ"."INV_END_DTTM"[DATE,7], "RQ"."INV_TYPE_CODE"[NUMBER,22], "RQ"."CHG_KEY"[NUMBER,22], "RQ"."CALL_INV_DTTM"[DATE,7], "RQ"."CHG_CODE"[NUMBER,22], "RQ"."DIST_BAND_CODE"[NUMBER,22], "RQ"."TIER_CODE"[NUMBER,22], "RQ"."CHG_TYPE_CODE"[NUMBER,22], "RQ"."CHG_ADJ_PCT"[NUMBER,22], "RQ"."USG_COMP_SCHM_CODE" 10 - (#keys=0) "RERATE_SEL_KEY"[NUMBER,22], "STATUS"[VARCHAR2,20], "RERATE_BATCH_KEY"[NUMBER,22] 11 - "RERATE_SEL_KEY"[NUMBER,22], "STATUS"[VARCHAR2,20], "RERATE_BATCH_KEY"[NUMBER,22] 12 - (#keys=0) "RERATE_SEL_KEY"[NUMBER,22], "STATUS"[VARCHAR2,20], "RERATE_BATCH_KEY"[NUMBER,22] 13 - "RERATE_SEL_KEY"[NUMBER,22], "RERATE_BATCH_KEY"[NUMBER,22], "STATUS"[VARCHAR2,20] Note ----- - dynamic sampling used for this statement (level=6) 217 rows selected. SQL> rollback; Rollback complete. SQL>