PLAN_TABLE_OUTPUT 1 Plan hash value: 222868954 2 3 --------------------------------------------------------------------------------------------------------------------------------------- 4 Id Operation Name Rows Bytes Cost (%CPU) Time Pstart Pstop 5 --------------------------------------------------------------------------------------------------------------------------------------- 6 0 SELECT STATEMENT 422 65455 4429 (1) 00:00:54 7 1 SORT ORDER BY 422 65455 4428 (62) 00:00:54 8 2 UNION-ALL 9 * 3 HASH JOIN 421 65255 1698 (1) 00:00:21 10 4 TABLE ACCESS FULL SOURCE 54 648 18 (0) 00:00:01 11 * 5 HASH JOIN 594 84942 1680 (1) 00:00:21 12 6 MERGE JOIN 594 50490 1592 (1) 00:00:20 13 7 TABLE ACCESS BY INDEX ROWID ERROR_MASTER 90 4680 4 (0) 00:00:01 14 * 8 INDEX FULL SCAN ERROR_MASTER_PK 90 1 (0) 00:00:01 15 * 9 SORT JOIN 601 19833 1588 (1) 00:00:20 16 * 10 TABLE ACCESS BY INDEX ROWID CHECKPOINT_ERROR 601 19833 1587 (1) 00:00:20 17 * 11 INDEX RANGE SCAN CHECKPOINT_ERROR_NU1 601 997 (1) 00:00:12 18 12 PARTITION RANGE SINGLE 1598 92684 87 (0) 00:00:02 29 29 19 * 13 TABLE ACCESS BY LOCAL INDEX ROWID UNFORMATTED_REINVESTMENT 1598 92684 87 (0) 00:00:02 29 29 20 * 14 INDEX RANGE SCAN UNFORMATTED_REINVESTMENT_NU1 365 9 (0) 00:00:01 29 29 21 15 NESTED LOOPS 1 200 2730 (1) 00:00:33 22 16 NESTED LOOPS 1 188 2729 (1) 00:00:33 23 17 NESTED LOOPS 1 111 2728 (1) 00:00:33 24 * 18 HASH JOIN 1 59 2727 (1) 00:00:33 25 19 VIEW 742 19292 998 (1) 00:00:12 26 20 SORT GROUP BY 742 21518 998 (1) 00:00:12 27 * 21 INDEX RANGE SCAN CHECKPOINT_ERROR_NU1 744 21576 997 (1) 00:00:12 28 * 22 TABLE ACCESS BY INDEX ROWID CHECKPOINT_ERROR 739 24387 1728 (1) 00:00:21 29 * 23 INDEX RANGE SCAN CHECKPOINT_ERROR_NU1 744 997 (1) 00:00:12 30 24 TABLE ACCESS BY INDEX ROWID ERROR_MASTER 1 52 1 (0) 00:00:01 31 * 25 INDEX UNIQUE SCAN ERROR_MASTER_PK 1 0 (0) 00:00:01 32 26 PARTITION RANGE SINGLE 1 77 1 (0) 00:00:01 29 29 33 * 27 TABLE ACCESS BY LOCAL INDEX ROWID UNFORMATTED_DEAL 1 77 1 (0) 00:00:01 29 29 34 * 28 INDEX UNIQUE SCAN UNFORMATTED_DEAL_PK 1 0 (0) 00:00:01 29 29 35 29 TABLE ACCESS BY INDEX ROWID SOURCE 1 12 1 (0) 00:00:01 36 * 30 INDEX UNIQUE SCAN SOURCE_PK 1 0 (0) 00:00:01 37 --------------------------------------------------------------------------------------------------------------------------------------- 38 39 Predicate Information (identified by operation id): 40 --------------------------------------------------- 41 42 3 - access("SR"."SOURCE_SQ"="UR"."SOURCE_SQ") 43 5 - access("CE"."RECORD_SQ"="UR"."REINVEST_SQ") 44 8 - filter("EM"."ERROR_ID"<>808 AND "EM"."ERROR_ID"<>809 AND "EM"."ERROR_ID"<>810 AND "EM"."ERROR_ID"<>811) 45 9 - access("CE"."ERROR_ID"="EM"."ERROR_ID") 46 filter("CE"."ERROR_ID"="EM"."ERROR_ID") 47 10 - filter("CE"."ERROR_ID"<>808 AND "CE"."ERROR_ID"<>809 AND "CE"."ERROR_ID"<>810 AND "CE"."ERROR_ID"<>811) 48 11 - access("CE"."CALENDAR_DT"=TO_DATE(' 2008-08-27 00:00:00', 'syyyy-mm-dd hh24:mi:ss') AND 49 "CE"."TABLE_NM_TXT"='UNFORMATTED_REINVESTMENT') 50 filter("CE"."TABLE_NM_TXT"='UNFORMATTED_REINVESTMENT') 51 13 - filter("UR"."STATUS_CD"<>'X') 52 14 - access("UR"."CALENDAR_DT"=TO_DATE(' 2008-08-27 00:00:00', 'syyyy-mm-dd hh24:mi:ss')) 53 18 - access("CE"."RECORD_SQ"="CH"."RECORD_SQ") 54 filter("CE"."ERROR_ID"=DECODE("CH"."REC_COUNT",1,"CE"."ERROR_ID",TO_NUMBER(DECODE("CE"."ERROR_ID",102,'',TO_CHAR("CE"."E 55 RROR_ID")))) AND DECODE("CH"."REC_COUNT",1,"CE"."ERROR_ID",TO_NUMBER(DECODE("CE"."ERROR_ID",102,'',TO_CHAR("CE"."ERROR_ID"))))< 56 >803 AND DECODE("CH"."REC_COUNT",1,"CE"."ERROR_ID",TO_NUMBER(DECODE("CE"."ERROR_ID",102,'',TO_CHAR("CE"."ERROR_ID"))))<>804 57 AND DECODE("CH"."REC_COUNT",1,"CE"."ERROR_ID",TO_NUMBER(DECODE("CE"."ERROR_ID",102,'',TO_CHAR("CE"."ERROR_ID"))))<>805 AND 58 DECODE("CH"."REC_COUNT",1,"CE"."ERROR_ID",TO_NUMBER(DECODE("CE"."ERROR_ID",102,'',TO_CHAR("CE"."ERROR_ID"))))<>806) 59 21 - access("CALENDAR_DT"=TO_DATE(' 2008-08-27 00:00:00', 'syyyy-mm-dd hh24:mi:ss') AND "TABLE_NM_TXT"='UNFORMATTED_DEAL') 60 filter("TABLE_NM_TXT"='UNFORMATTED_DEAL') 61 22 - filter("CE"."ERROR_ID"<>803 AND "CE"."ERROR_ID"<>806 AND "CE"."ERROR_ID"<>804 AND "CE"."ERROR_ID"<>805) 62 23 - access("CE"."CALENDAR_DT"=TO_DATE(' 2008-08-27 00:00:00', 'syyyy-mm-dd hh24:mi:ss') AND 63 "CE"."TABLE_NM_TXT"='UNFORMATTED_DEAL') 64 filter("CE"."TABLE_NM_TXT"='UNFORMATTED_DEAL') 65 25 - access("CE"."ERROR_ID"="EM"."ERROR_ID") 66 filter("EM"."ERROR_ID"<>803 AND "EM"."ERROR_ID"<>804 AND "EM"."ERROR_ID"<>805 AND "EM"."ERROR_ID"<>806) 67 27 - filter("UD"."STATUS_CD"<>'X') 68 28 - access("UD"."CALENDAR_DT"=TO_DATE(' 2008-08-27 00:00:00', 'syyyy-mm-dd hh24:mi:ss') AND "CE"."RECORD_SQ"="UD"."DEAL_SQ") 69 30 - access("SR"."SOURCE_SQ"="UD"."SOURCE_SQ") 70 71 Note 72 ----- 73 - 'PLAN_TABLE' is old version