PLAN_TABLE_OUTPUT Plan hash value: 380279546 ------------------------------------------------------------------------------------------------------------------------------------------------ Id Operation Name Rows Bytes TempSpc Cost (%CPU) Time Pstart Pstop ------------------------------------------------------------------------------------------------------------------------------------------------ 0 SELECT STATEMENT 1603 263K 362 (2) 00:00:05 1 SORT ORDER BY 1603 263K 680K 289 (54) 00:00:04 2 UNION-ALL * 3 HASH JOIN 1123 169K 136 (3) 00:00:02 4 TABLE ACCESS FULL SOURCE 54 648 18 (0) 00:00:01 * 5 HASH JOIN 1583 221K 117 (2) 00:00:02 6 PARTITION RANGE SINGLE 1589 92162 87 (0) 00:00:02 29 29 * 7 TABLE ACCESS BY LOCAL INDEX ROWID UNFORMATTED_REINVESTMENT 1589 92162 87 (0) 00:00:02 29 29 * 8 INDEX RANGE SCAN UNFORMATTED_REINVESTMENT_NU1 363 9 (0) 00:00:01 29 29 9 MERGE JOIN 3402 282K 29 (4) 00:00:01 10 TABLE ACCESS BY INDEX ROWID ERROR_MASTER 90 4680 4 (0) 00:00:01 * 11 INDEX FULL SCAN ERROR_MASTER_PK 90 1 (0) 00:00:01 * 12 SORT JOIN 3438 110K 25 (4) 00:00:01 * 13 INDEX RANGE SCAN CHECKPOINT_ERROR_NU3 3438 110K 24 (0) 00:00:01 * 14 HASH JOIN 480 96000 153 (2) 00:00:02 * 15 HASH JOIN 482 83868 123 (2) 00:00:02 16 TABLE ACCESS FULL SOURCE 54 648 18 (0) 00:00:01 * 17 HASH JOIN 962 152K 105 (2) 00:00:02 18 PARTITION RANGE SINGLE 963 74151 70 (0) 00:00:01 29 29 * 19 TABLE ACCESS BY LOCAL INDEX ROWID UNFORMATTED_DEAL 963 74151 70 (0) 00:00:01 29 29 * 20 INDEX SKIP SCAN UNFORMATTED_DEAL_NU1 213 7 (0) 00:00:01 29 29 21 MERGE JOIN 4185 347K 34 (3) 00:00:01 22 TABLE ACCESS BY INDEX ROWID ERROR_MASTER 90 4680 4 (0) 00:00:01 * 23 INDEX FULL SCAN ERROR_MASTER_PK 90 1 (0) 00:00:01 * 24 SORT JOIN 4228 136K 30 (4) 00:00:01 * 25 INDEX RANGE SCAN CHECKPOINT_ERROR_NU3 4228 136K 29 (0) 00:00:01 26 VIEW 4218 107K 29 (0) 00:00:01 27 SORT GROUP BY 4218 119K 29 (0) 00:00:01 * 28 INDEX RANGE SCAN CHECKPOINT_ERROR_NU3 4256 120K 29 (0) 00:00:01 ------------------------------------------------------------------------------------------------------------------------------------------------ Predicate Information (identified by operation id): --------------------------------------------------- 3 - access("SR"."SOURCE_SQ"="UR"."SOURCE_SQ") 5 - access("CE"."RECORD_SQ"="UR"."REINVEST_SQ") 7 - filter("UR"."STATUS_CD"<>'X') 8 - access("UR"."CALENDAR_DT"=TO_DATE(' 2008-08-15 00:00:00', 'syyyy-mm-dd hh24:mi:ss')) 11 - filter("EM"."ERROR_ID"<>808 AND "EM"."ERROR_ID"<>809 AND "EM"."ERROR_ID"<>810 AND "EM"."ERROR_ID"<>811) 12 - access("CE"."ERROR_ID"="EM"."ERROR_ID") filter("CE"."ERROR_ID"="EM"."ERROR_ID") 13 - access("CE"."CALENDAR_DT"=TO_DATE(' 2008-08-15 00:00:00', 'syyyy-mm-dd hh24:mi:ss') AND "CE"."TABLE_NM_TXT"='UNFORMATTED_REINVESTMENT') filter("CE"."ERROR_ID"<>808 AND "CE"."ERROR_ID"<>809 AND "CE"."ERROR_ID"<>810 AND "CE"."ERROR_ID"<>811) 14 - access("CE"."RECORD_SQ"="CH"."RECORD_SQ") filter("CE"."ERROR_ID"<>102 OR "CH"."REC_COUNT"=1) 15 - access("SR"."SOURCE_SQ"="UD"."SOURCE_SQ") 17 - access("CE"."RECORD_SQ"="UD"."DEAL_SQ") 19 - filter("UD"."STATUS_CD"<>'X') 20 - access("UD"."CALENDAR_DT"=TO_DATE(' 2008-08-15 00:00:00', 'syyyy-mm-dd hh24:mi:ss')) 23 - filter("EM"."ERROR_ID"<>803 AND "EM"."ERROR_ID"<>804 AND "EM"."ERROR_ID"<>805 AND "EM"."ERROR_ID"<>806) 24 - access("CE"."ERROR_ID"="EM"."ERROR_ID") filter("CE"."ERROR_ID"="EM"."ERROR_ID") 25 - access("CE"."CALENDAR_DT"=TO_DATE(' 2008-08-15 00:00:00', 'syyyy-mm-dd hh24:mi:ss') AND "CE"."TABLE_NM_TXT"='UNFORMATTED_DEAL') filter("CE"."ERROR_ID"<>803 AND "CE"."ERROR_ID"<>806 AND "CE"."ERROR_ID"<>804 AND "CE"."ERROR_ID"<>805) 28 - access("CALENDAR_DT"=TO_DATE(' 2008-08-15 00:00:00', 'syyyy-mm-dd hh24:mi:ss') AND "TABLE_NM_TXT"='UNFORMATTED_DEAL') filter("TABLE_NM_TXT"='UNFORMATTED_DEAL' AND "CALENDAR_DT"=TO_DATE(' 2008-08-15 00:00:00', 'syyyy-mm-dd hh24:mi:ss')) Note ----- - 'PLAN_TABLE' is old version