TKPROF: Release 11.1.0.7.0 - Production on Tue Apr 19 18:53:11 2011 Copyright (c) 1982, 2007, Oracle. All rights reserved. Trace file: COBALT_ora_15043.trc Sort options: default ******************************************************************************** count = number of times OCI procedure was executed cpu = cpu time in seconds executing elapsed = elapsed time in seconds executing disk = number of physical reads of buffers from disk query = number of buffers gotten for consistent read current = number of buffers gotten in current mode (usually for update) rows = number of rows processed by the fetch or execute call ******************************************************************************** SQL ID: 01zz6tw1wn6fv Plan Hash: 1106083767 SELECT "ESTIMATE_NBR" ,"VERSION_NBR" ,"ESTIMATE_NAME" ,"EVENT_TYPE" FROM "CIRQIT"."ESTIMATE" WHERE ("ESTIMATE_NBR" = :1 AND "VERSION_NBR" = :2) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 0 0.00 0.00 0 0 0 0 Fetch 1 0.01 0.02 734 871 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 1 0.01 0.02 734 871 0 0 Misses in library cache during parse: 0 Parsing user id: 103 (???) ******************************************************************************** SQL ID: 459jph41hwnkj Plan Hash: 2198183789 SELECT "ORDER_NBR" ,MIN("TOTAL" ) FROM "CIRQRPT"."ORDER_EST_ACTUAL_PERCENT" GROUP BY "ORDER_NBR" ,"PARENT_ORG_ID" , "AWARDED_TOTAL" call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.02 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 4 0.01 0.00 0 657 0 7115 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.01 0.02 0 657 0 7115 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 103 (CIRQRPT) Rows Row Source Operation ------- --------------------------------------------------- 7115 HASH GROUP BY (cr=657 pr=0 pw=0 time=0 us cost=186 size=285247 card=15013) 15013 TABLE ACCESS FULL ORDER_EST_ACTUAL_PERCENT (cr=657 pr=0 pw=0 time=0 us cost=184 size=285247 card=15013) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 7115 HASH (GROUP BY) 15013 TABLE ACCESS MODE: ANALYZED (FULL) OF 'ORDER_EST_ACTUAL_PERCENT' (TABLE) ******************************************************************************** SQL ID: 1ssgfcdu8uzp1 Plan Hash: 346858368 SELECT "PARENT_ORG_ID" ,"ORDER_NBR" ,"TOTAL" ,"AWARDED_TOTAL" FROM "CIRQRPT"."ORDER_EST_ACTUAL_PERCENT" WHERE ((("PARENT_ORG_ID" = 1571 ) AND ("NBR_ESTIMATES" > 1 ) ) AND ("ORDER_DATE" BETWEEN :1 AND :2 ) ) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 2 0.00 0.02 0 658 0 33 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.00 0.02 0 658 0 33 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 103 (CIRQRPT) Rows Row Source Operation ------- --------------------------------------------------- 33 FILTER (cr=658 pr=0 pw=0 time=0 us) 33 TABLE ACCESS FULL ORDER_EST_ACTUAL_PERCENT (cr=658 pr=0 pw=0 time=0 us cost=184 size=840 card=28) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 33 FILTER 33 TABLE ACCESS MODE: ANALYZED (FULL) OF 'ORDER_EST_ACTUAL_PERCENT' (TABLE) ******************************************************************************** SQL ID: 7q6p8b84q68bv Plan Hash: 3143791388 SELECT "ORDER_NBR" ,"AWARDED_TOTAL" ,"PARENT_ORG_ID" ,MIN("TOTAL" ) FROM "CIRQRPT"."ORDER_EST_ACTUAL_PERCENT" WHERE (((("PARENT_ORG_ID" = 1571 ) AND ("NBR_ESTIMATES" > 1 ) ) AND ("WIN_LOSE" = 'Lost' ) ) AND ("ORDER_DATE" BETWEEN :1 AND :2 ) ) GROUP BY "ORDER_NBR" ,"PARENT_ORG_ID" , "AWARDED_TOTAL" ,"PARENT_ORG_ID" call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 2 0.00 0.00 0 657 0 8 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.00 0.00 0 657 0 8 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 103 (CIRQRPT) Rows Row Source Operation ------- --------------------------------------------------- 8 HASH GROUP BY (cr=657 pr=0 pw=0 time=0 us cost=185 size=525 card=15) 25 FILTER (cr=657 pr=0 pw=0 time=0 us) 25 TABLE ACCESS FULL ORDER_EST_ACTUAL_PERCENT (cr=657 pr=0 pw=0 time=0 us cost=184 size=525 card=15) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 8 HASH (GROUP BY) 25 FILTER 25 TABLE ACCESS MODE: ANALYZED (FULL) OF 'ORDER_EST_ACTUAL_PERCENT' (TABLE) ******************************************************************************** SQL ID: 7y7qnbpuk4tb4 Plan Hash: 2548052735 SELECT "PARENT_ORG_ID" ,"ORDER_NBR" ,"WIN_LOSE" ,"TOTAL" FROM "CIRQRPT"."ORDER_EST_ACTUAL_PERCENT" WHERE (("WIN_LOSE" = 'Lost' ) AND ("PARENT_ORG_ID" = 1571 ) ) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 9 0.00 0.00 0 665 0 7898 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 11 0.00 0.00 0 665 0 7898 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 103 (CIRQRPT) Rows Row Source Operation ------- --------------------------------------------------- 7898 TABLE ACCESS FULL ORDER_EST_ACTUAL_PERCENT (cr=665 pr=0 pw=0 time=0 us cost=184 size=150062 card=7898) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 7898 TABLE ACCESS MODE: ANALYZED (FULL) OF 'ORDER_EST_ACTUAL_PERCENT' (TABLE) ******************************************************************************** SQL ID: 72cbp8z7r5zga Plan Hash: 3143791388 SELECT "ORDER_NBR" ,MIN("TOTAL" ) FROM "CIRQRPT"."ORDER_EST_ACTUAL_PERCENT" WHERE ((("PARENT_ORG_ID" = 1571 ) AND ("ORDER_DATE" >= :1 ) ) AND ("ORDER_DATE" < :2 ) ) GROUP BY "ORDER_NBR" , "PARENT_ORG_ID" ,"ORDER_DATE" call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 2 0.00 0.00 0 657 0 24 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.00 0.00 0 657 0 24 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 103 (CIRQRPT) Rows Row Source Operation ------- --------------------------------------------------- 24 HASH GROUP BY (cr=657 pr=0 pw=0 time=0 us cost=185 size=836 card=38) 49 FILTER (cr=657 pr=0 pw=0 time=0 us) 49 TABLE ACCESS FULL ORDER_EST_ACTUAL_PERCENT (cr=657 pr=0 pw=0 time=0 us cost=184 size=836 card=38) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 24 HASH (GROUP BY) 49 FILTER 49 TABLE ACCESS MODE: ANALYZED (FULL) OF 'ORDER_EST_ACTUAL_PERCENT' (TABLE) ******************************************************************************** SQL ID: 7xghub5hk8j2m Plan Hash: 2548052735 SELECT "ORG_ID" ,"ORDER_NBR" ,"SUPPLIER" ,"TOTAL" ,"AWARDEDNAME" , "AWARDED_TOTAL" FROM "CIRQRPT"."ORDER_EST_ACTUAL_PERCENT" WHERE (("PARENT_ORG_ID" = 1571 ) AND (("WIN_LOSE" = 'Won' ) AND ( :1 = "ORDER_NBR" ) ) ) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 2 0.01 0.02 0 658 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.01 0.02 0 658 0 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 103 (CIRQRPT) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS FULL ORDER_EST_ACTUAL_PERCENT (cr=658 pr=0 pw=0 time=0 us cost=184 size=68 card=1) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 1 TABLE ACCESS MODE: ANALYZED (FULL) OF 'ORDER_EST_ACTUAL_PERCENT' (TABLE) ******************************************************************************** SQL ID: 505qm7rbff6rg Plan Hash: 2198183789 SELECT "ORDER_NBR" ,MIN("TOTAL" ) FROM "CIRQRPT"."ORDER_EST_ACTUAL_PERCENT" GROUP BY "ORDER_NBR" ,"AWARDED_TOTAL" call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 4 0.01 0.00 0 657 0 7115 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.01 0.00 0 657 0 7115 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 103 (CIRQRPT) Rows Row Source Operation ------- --------------------------------------------------- 7115 HASH GROUP BY (cr=657 pr=0 pw=0 time=0 us cost=186 size=225195 card=15013) 15013 TABLE ACCESS FULL ORDER_EST_ACTUAL_PERCENT (cr=657 pr=0 pw=0 time=0 us cost=184 size=225195 card=15013) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 7115 HASH (GROUP BY) 15013 TABLE ACCESS MODE: ANALYZED (FULL) OF 'ORDER_EST_ACTUAL_PERCENT' (TABLE) ******************************************************************************** SQL ID: 2r24nwx77126z Plan Hash: 2548052735 SELECT "ORDER_NBR" ,"TOTAL" ,"AWARDED_TOTAL" FROM "CIRQRPT"."ORDER_EST_ACTUAL_PERCENT" WHERE ("PARENT_ORG_ID" = 1571 ) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 10 0.00 0.00 0 666 0 15013 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 12 0.01 0.00 0 666 0 15013 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 103 (CIRQRPT) Rows Row Source Operation ------- --------------------------------------------------- 15013 TABLE ACCESS FULL ORDER_EST_ACTUAL_PERCENT (cr=666 pr=0 pw=0 time=0 us cost=184 size=285247 card=15013) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 15013 TABLE ACCESS MODE: ANALYZED (FULL) OF 'ORDER_EST_ACTUAL_PERCENT' (TABLE) ******************************************************************************** SQL ID: 35cj7kgh1s4ya Plan Hash: 2198183789 SELECT "ORDER_NBR" ,"AWARDED_TOTAL" ,MIN("TOTAL" ) FROM "CIRQRPT"."ORDER_EST_ACTUAL_PERCENT" WHERE ("PARENT_ORG_ID" = 1571 ) GROUP BY "ORDER_NBR" ,"AWARDED_TOTAL" call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 6 0.01 0.02 0 657 0 7115 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 8 0.01 0.02 0 657 0 7115 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 103 (CIRQRPT) Rows Row Source Operation ------- --------------------------------------------------- 7115 HASH GROUP BY (cr=657 pr=0 pw=0 time=0 us cost=186 size=285247 card=15013) 15013 TABLE ACCESS FULL ORDER_EST_ACTUAL_PERCENT (cr=657 pr=0 pw=0 time=0 us cost=184 size=285247 card=15013) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 7115 HASH (GROUP BY) 15013 TABLE ACCESS MODE: ANALYZED (FULL) OF 'ORDER_EST_ACTUAL_PERCENT' (TABLE) ******************************************************************************** SQL ID: 3ugw4c3w29tdj Plan Hash: 992642767 SELECT "CIRQIT"."ORDER_CUSTOM_FIELD"."ORDER_NBR" , "CIRQIT"."ORDER_CUSTOM_FIELD"."FIELD_VALUE" FROM "CIRQIT"."PBVORG","CIRQIT"."PRODUCT_ORDER","CIRQIT"."ORDER_CUSTOM_FIELD" WHERE (((("CIRQIT"."PBVORG"."PARENT_ORG_ID" = 1571 ) AND ("CIRQIT"."PRODUCT_ORDER"."CLIENT_ORG_ID" = "CIRQIT"."PBVORG"."ORG_ID" ) ) AND ("CIRQIT"."PRODUCT_ORDER"."ORDER_NBR" = "CIRQIT"."ORDER_CUSTOM_FIELD"."ORDER_NBR" ) ) AND (("CIRQIT"."ORDER_CUSTOM_FIELD"."CUSTOM_FIELD_NAME" = 'Other' ) AND NOT(("CIRQIT"."ORDER_CUSTOM_FIELD"."FIELD_VALUE" = ' ' ) ) ) ) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.01 0.02 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 21 0.03 0.37 324 8417 0 621 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 23 0.04 0.39 324 8417 0 621 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 103 (CIRQRPT) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 0 NESTED LOOPS 0 NESTED LOOPS 0 NESTED LOOPS 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'PBVORG' (TABLE) 0 INDEX MODE: ANALYZED (RANGE SCAN) OF 'PBVORG_PARENT_INDX' (INDEX) 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'PRODUCT_ORDER' (TABLE) 0 INDEX MODE: ANALYZED (RANGE SCAN) OF 'CLIENT_ORG_ID_ORDER_INDX' (INDEX) 0 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'ORDER_CUSTOM_FIELD_PK' (INDEX (UNIQUE)) 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'ORDER_CUSTOM_FIELD' (TABLE) ******************************************************************************** SQL ID: 8ugadbamuxp81 Plan Hash: 1834208933 SELECT "CIRQIT"."ORDER_CUSTOM_FIELD"."ORDER_NBR" , "CIRQIT"."CUSTOM_FIELD_LOOKUP_VALUE"."DESCRIPTION" FROM "CIRQIT"."PBVORG","CIRQIT"."PRODUCT_ORDER","CIRQIT"."ORDER_CUSTOM_FIELD", "CIRQIT"."CUSTOM_FIELD_LOOKUP_VALUE" WHERE (((("CIRQIT"."ORDER_CUSTOM_FIELD"."CUSTOM_FIELD_NAME" = "CIRQIT"."CUSTOM_FIELD_LOOKUP_VALUE"."CUSTOM_FIELD_NAME"(+)) AND ("CIRQIT"."ORDER_CUSTOM_FIELD"."LOOKUP_VALUE_NBR" = "CIRQIT"."CUSTOM_FIELD_LOOKUP_VALUE"."LOOKUP_VALUE_NBR"(+))))) AND (((((("CIRQIT"."PBVORG"."PARENT_ORG_ID" = 1571 ) AND ("CIRQIT"."PRODUCT_ORDER"."CLIENT_ORG_ID" = "CIRQIT"."PBVORG"."ORG_ID" ) ) AND ("CIRQIT"."PRODUCT_ORDER"."ORDER_NBR" = "CIRQIT"."ORDER_CUSTOM_FIELD"."ORDER_NBR" ) ) AND ("CIRQIT"."ORDER_CUSTOM_FIELD"."CUSTOM_FIELD_NAME" = 'VendSelCrit2' ) ) AND (NOT(("CIRQIT"."CUSTOM_FIELD_LOOKUP_VALUE"."DESCRIPTION" = ' ' ) ) AND NOT(("CIRQIT"."CUSTOM_FIELD_LOOKUP_VALUE"."DESCRIPTION" = 'Other' ) ) ) )) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 16 0.29 5.92 5930 43591 0 7357 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 18 0.30 5.92 5930 43591 0 7357 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 103 (CIRQRPT) Rows Row Source Operation ------- --------------------------------------------------- 7357 HASH JOIN (cr=43591 pr=5930 pw=0 time=0 us cost=1084 size=75 card=1) 12058 NESTED LOOPS (cr=43582 pr=5927 pw=0 time=21007 us) 12058 NESTED LOOPS (cr=31524 pr=1350 pw=0 time=21007 us cost=1080 size=148 card=4) 12059 NESTED LOOPS (cr=8154 pr=0 pw=0 time=0 us cost=231 size=10659 card=561) 18 TABLE ACCESS BY INDEX ROWID PBVORG (cr=7 pr=0 pw=0 time=0 us cost=2 size=9 card=1) 18 INDEX RANGE SCAN PBVORG_PARENT_INDX (cr=2 pr=0 pw=0 time=0 us cost=1 size=0 card=1)(object id 169783) 12059 TABLE ACCESS BY INDEX ROWID PRODUCT_ORDER (cr=8147 pr=0 pw=0 time=0 us cost=229 size=4470 card=447) 12059 INDEX RANGE SCAN CLIENT_ORG_ID_ORDER_INDX (cr=45 pr=0 pw=0 time=0 us cost=1 size=0 card=447)(object id 169847) 12058 INDEX UNIQUE SCAN ORDER_CUSTOM_FIELD_PK (cr=23370 pr=1350 pw=0 time=0 us cost=1 size=0 card=1)(object id 169999) 12058 TABLE ACCESS BY INDEX ROWID ORDER_CUSTOM_FIELD (cr=12058 pr=4577 pw=0 time=0 us cost=2 size=18 card=1) 4 TABLE ACCESS BY INDEX ROWID CUSTOM_FIELD_LOOKUP_VALUE (cr=9 pr=3 pw=0 time=0 us cost=3 size=228 card=6) 5 INDEX RANGE SCAN CUSTOM_FIELD_LOOKUP_VALUE_PK (cr=5 pr=2 pw=0 time=0 us cost=2 size=0 card=6)(object id 169626) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 7357 HASH JOIN 12058 NESTED LOOPS 12058 NESTED LOOPS 12059 NESTED LOOPS 18 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'PBVORG' (TABLE) 18 INDEX MODE: ANALYZED (RANGE SCAN) OF 'PBVORG_PARENT_INDX' (INDEX) 12059 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'PRODUCT_ORDER' (TABLE) 12059 INDEX MODE: ANALYZED (RANGE SCAN) OF 'CLIENT_ORG_ID_ORDER_INDX' (INDEX) 12058 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'ORDER_CUSTOM_FIELD_PK' (INDEX (UNIQUE)) 12058 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'ORDER_CUSTOM_FIELD' (TABLE) 4 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'CUSTOM_FIELD_LOOKUP_VALUE' (TABLE) 5 INDEX MODE: ANALYZED (RANGE SCAN) OF 'CUSTOM_FIELD_LOOKUP_VALUE_PK' (INDEX (UNIQUE)) ******************************************************************************** SQL ID: 24pqb0fhnp6sz Plan Hash: 798521164 SELECT "CIRQRPT"."ORDER_EST_ACTUAL_PERCENT"."ORDER_NBR" , "CIRQIT"."PRODUCT_ORDER"."ORDER_NBR" FROM "CIRQRPT"."ORDER_EST_ACTUAL_PERCENT","CIRQIT"."PRODUCT_ORDER" WHERE ((("CIRQRPT"."ORDER_EST_ACTUAL_PERCENT"."PARENT_ORG_ID" = 1571 ) AND ("CIRQRPT"."ORDER_EST_ACTUAL_PERCENT"."WIN_LOSE" = 'Won' ) ) AND ("CIRQRPT"."ORDER_EST_ACTUAL_PERCENT"."ORDER_NBR" = "CIRQIT"."PRODUCT_ORDER"."ORDER_NBR" ) ) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 2 0.00 0.23 239 2992 0 2667 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.01 0.23 239 2992 0 2667 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 103 (CIRQRPT) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 0 NESTED LOOPS 0 TABLE ACCESS MODE: ANALYZED (FULL) OF 'ORDER_EST_ACTUAL_PERCENT' (TABLE) 0 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'PRODUCT_ORDER_PK' (INDEX (UNIQUE)) ******************************************************************************** OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 12 0.02 0.04 0 0 0 0 Execute 12 0.00 0.00 0 0 0 0 Fetch 81 0.44 6.61 7227 61803 0 54967 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 105 0.47 6.65 7227 61803 0 54967 Misses in library cache during parse: 12 Misses in library cache during execute: 4 OVERALL TOTALS FOR ALL RECURSIVE STATEMENTS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 40 0.00 0.00 0 0 0 0 Execute 118 0.01 0.00 0 0 0 0 Fetch 216 0.00 0.08 13 484 0 518 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 374 0.02 0.08 13 484 0 518 Misses in library cache during parse: 2 Misses in library cache during execute: 2 13 user SQL statements in session. 118 internal SQL statements in session. 131 SQL statements in session. 12 statements EXPLAINed in this session. ******************************************************************************** Trace file: COBALT_ora_15043.trc Trace file compatibility: 11.1.0.7 Sort options: default 1 session in tracefile. 13 user SQL statements in trace file. 118 internal SQL statements in trace file. 131 SQL statements in trace file. 29 unique SQL statements in trace file. 12 SQL statements EXPLAINed using schema: SYSTEM.prof$plan_table Default table was used. Table was created. Table was dropped. 1335 lines in trace file. 13 elapsed seconds in trace file.