TKPROF: Release 10.2.0.3.0 - Production on Tue Jun 18 11:26:23 2013 Copyright (c) 1982, 2005, Oracle. All rights reserved. Trace file: is01_ora_15318.trc Sort options: prsela exeela fchela ******************************************************************************** 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 ******************************************************************************** SELECT HD.CONO, HD.CUSTNO, HD.EXTERNALCONO, CR.STOCKNOSU, CR.TOURNO FROM EHDA.COHEAD HD,EHDA.A_COSHIPTO CR,EHDA.A_COFLX CF WHERE HD.CONO = CR.CONO AND HD.OTYPE = 61 AND EXISTS (SELECT 'x' FROM ehda.COROW CR2 WHERE CR2.ROWSTATUS BETWEEN 790 AND 989 AND CR2.CONO = CR.CONO AND CR2.TOURNO = CR.TOURNO AND CR.COSHIPTOSEQNO = CR2.COSHIPTOSEQNO) AND HD.CONO = CF.CONO AND CR.COSHIPTOSEQNO = CF.COSHIPTOSEQNO AND CF.COREFQUAL = 'PRINT_FLAG' AND CF.CHARVALUE IS NULL call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.12 0.13 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 4 9.14 322.01 47022 261005 0 44 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 9.26 322.15 47022 261005 0 44 Misses in library cache during parse: 1 Optimizer mode: FIRST_ROWS Parsing user id: 19 ******************************************************************************** OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.12 0.13 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 4 9.14 322.01 47022 261005 0 44 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 9.26 322.15 47022 261005 0 44 Misses in library cache during parse: 1 OVERALL TOTALS FOR ALL RECURSIVE STATEMENTS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 18 0.05 0.01 0 0 0 0 Execute 490 0.11 0.17 0 0 0 0 Fetch 1301 0.10 2.94 249 1889 0 5216 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 1809 0.26 3.12 249 1889 0 5216 Misses in library cache during parse: 14 Misses in library cache during execute: 14 1 user SQL statements in session. 490 internal SQL statements in session. 491 SQL statements in session. ******************************************************************************** Trace file: is01_ora_15318.trc Trace file compatibility: 10.01.00 Sort options: prsela exeela fchela 1 session in tracefile. 1 user SQL statements in trace file. 490 internal SQL statements in trace file. 491 SQL statements in trace file. 15 unique SQL statements in trace file. 5477 lines in trace file. 325 elapsed seconds in trace file.