TKPROF: Release 11.1.0.7.0 - Production on Tue Apr 19 18:34:03 2011 Copyright (c) 1982, 2007, Oracle. All rights reserved. Trace file: COBALT_ora_3548.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: 7ndn358uwqmnt Plan Hash: 395317010 SELECT "CIRQIT"."PRODUCT_ORDER"."CLIENT_ORG_ID" , "CIRQIT"."ORDER_ITEM_MAP"."ORDER_NBR" , SUM("CIRQIT"."ORDER_ITEM_MAP"."ORDER_QTY" ) FROM "CIRQIT"."ORDER_ITEM_MAP","CIRQIT"."PBVORG","CIRQIT"."PRODUCT_ORDER", "CIRQIT"."ITEM" WHERE (("CIRQIT"."ITEM"."ITEM_NBR" = "CIRQIT"."ORDER_ITEM_MAP"."ITEM_NBR" ) AND ((("CIRQIT"."PBVORG"."PARENT_ORG_ID" = 1571 ) AND ("CIRQIT"."PRODUCT_ORDER"."CLIENT_ORG_ID" = "CIRQIT"."PBVORG"."ORG_ID" ) ) AND (("CIRQIT"."PRODUCT_ORDER"."ESTIMATE_NBR" = "CIRQIT"."ITEM"."ESTIMATE_NBR" ) AND ("CIRQIT"."PRODUCT_ORDER"."VERSION_NBR" = "CIRQIT"."ITEM"."VERSION_NBR" ) ) ) ) GROUP BY "CIRQIT"."PRODUCT_ORDER"."CLIENT_ORG_ID" , "CIRQIT"."ORDER_ITEM_MAP"."ORDER_NBR" ,"CIRQIT"."PBVORG"."PARENT_ORG_ID" 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 6 0.00 0.00 0 0 0 7680 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.00 0.00 0 0 0 7680 Misses in library cache during parse: 0 Parsing user id: 103 (???) ******************************************************************************** SQL ID: cj97p0v0ck8z1 Plan Hash: 2673472880 SELECT "CIRQRPT"."ORDER_EST_ACTUAL_PERCENT"."ORG_ID" , "CIRQRPT"."ORDER_EST_ACTUAL_PERCENT"."ORDER_NBR" , "CIRQRPT"."ORDER_EST_ACTUAL_PERCENT"."NBR_ESTIMATES" , "CIRQIT"."PRODUCT_ORDER"."ORDER_NBR" , "CIRQIT"."PRODUCT_ORDER"."ESTIMATE_NBR" , "CIRQIT"."PRODUCT_ORDER"."VERSION_NBR" , "CIRQIT"."PRODUCT_ORDER"."ORDER_DATE" ,"CIRQIT"."PBVUSER"."USER_FIRST_NAME" ,"CIRQIT"."PBVUSER"."USER_LAST_NAME" ,"CIRQIT"."PBVORG"."ORG_NAME" FROM "CIRQRPT"."ORDER_EST_ACTUAL_PERCENT","CIRQIT"."PRODUCT_ORDER", "CIRQIT"."PBVUSER","CIRQIT"."PBVORG" WHERE (((((("CIRQRPT"."ORDER_EST_ACTUAL_PERCENT"."WIN_LOSE" = 'Won' ) AND ("CIRQRPT"."ORDER_EST_ACTUAL_PERCENT"."PARENT_ORG_ID" = 1571 ) ) AND ("CIRQIT"."PRODUCT_ORDER"."ORDER_NBR" = "CIRQRPT"."ORDER_EST_ACTUAL_PERCENT"."ORDER_NBR" ) ) AND (("CIRQIT"."PRODUCT_ORDER"."ORDER_DATE" >= :1 ) AND ("CIRQIT"."PRODUCT_ORDER"."ORDER_DATE" < :2 ) ) ) AND ("CIRQIT"."PRODUCT_ORDER"."PRIMARY_CONTACT_USER_ID" = "CIRQIT"."PBVUSER"."USER_ID" ) ) AND (("CIRQRPT"."ORDER_EST_ACTUAL_PERCENT"."ORG_ID" = "CIRQIT"."PBVORG"."ORG_ID" ) AND ("CIRQIT"."PRODUCT_ORDER"."CLIENT_ORG_ID" = "CIRQIT"."PBVORG"."ORG_ID" ) ) ) 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.00 0.27 293 464 0 89 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 1 0.00 0.27 293 464 0 89 Misses in library cache during parse: 0 Parsing user id: 103 (???) ******************************************************************************** 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 1 0.00 0.00 0 0 0 0 Execute 107 0.02 0.06 0 0 0 0 Fetch 214 44.68 53.06 2754932 2755673 0 107 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 322 44.71 53.12 2754932 2755673 0 107 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 ESTIMATE (cr=25755 pr=25750 pw=0 time=0 us cost=7049 size=41 card=1) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'ESTIMATE' (TABLE) 0 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'ESTIMATE_PK' (INDEX (UNIQUE)) ******************************************************************************** OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 107 0.02 0.06 0 0 0 0 Fetch 221 44.69 53.33 2755225 2756137 0 7876 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 329 44.72 53.40 2755225 2756137 0 7876 Misses in library cache during parse: 1 Misses in library cache during execute: 1 OVERALL TOTALS FOR ALL RECURSIVE STATEMENTS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 29 0.00 0.00 0 0 0 0 Execute 205 0.03 0.06 0 0 0 0 Fetch 356 0.01 0.63 31 783 0 1210 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 590 0.05 0.69 31 783 0 1210 Misses in library cache during parse: 14 Misses in library cache during execute: 14 3 user SQL statements in session. 205 internal SQL statements in session. 208 SQL statements in session. 1 statement EXPLAINed in this session. ******************************************************************************** Trace file: COBALT_ora_3548.trc Trace file compatibility: 11.1.0.7 Sort options: default 1 session in tracefile. 3 user SQL statements in trace file. 205 internal SQL statements in trace file. 208 SQL statements in trace file. 17 unique SQL statements in trace file. 1 SQL statements EXPLAINed using schema: SYSTEM.prof$plan_table Default table was used. Table was created. Table was dropped. 2141 lines in trace file. 62 elapsed seconds in trace file.