TKPROF: Release 10.2.0.1.0 - Production on Wed Jun 4 05:52:14 2008 Copyright (c) 1982, 2005, Oracle. All rights reserved. Trace file: billtest_ora_23964.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 ******************************************************************************** alter session set sql_trace=true call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 1 0.00 0.00 0 0 0 0 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 48 ******************************************************************************** select CALL_DATE, PARTNER_CODE, CALL_DIRECTION,SERVICE_CODE,A_NUMBER, B_NUMBER ,TIME_TYPE,AGREEMENT_TYPE, dump(B_NUMBER), Length(B_NUMBER) LEN from RATED_CALL where CALL_DATE between TO_DATE('4/24/2008 7:10:27 PM','MM/DD/YYYY HH:MI:SS PM') and TO_DATE('4/24/2008 7:10:40 PM','MM/DD/YYYY HH:MI:SS PM') and PARTNER_CODE='FK6' and CALL_DIRECTION='I' and SERVICE_CODE='000' and A_NUMBER= 256753557095 and B_NUMBER =256714765489 and TIME_TYPE='STA' AND AGREEMENT_TYPE='I' 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.02 0.02 0 1068 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.02 0.02 0 1068 0 3 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 48 Rows Row Source Operation ------- --------------------------------------------------- 3 PARTITION RANGE SINGLE PARTITION: 56 56 (cr=1068 pr=0 pw=0 time=3785 us) 3 TABLE ACCESS FULL rated_calls PARTITION: 56 56 (cr=1068 pr=0 pw=0 time=3741 us) ******************************************************************************** alter session set sql_trace=false 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 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 0 0 0 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 48 ******************************************************************************** OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 0 0 Execute 3 0.00 0.00 0 0 0 0 Fetch 2 0.02 0.02 0 1068 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 7 0.02 0.02 0 1068 0 3 Misses in library cache during parse: 0 OVERALL TOTALS FOR ALL RECURSIVE STATEMENTS 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 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 0 0.00 0.00 0 0 0 0 Misses in library cache during parse: 0 3 user SQL statements in session. 0 internal SQL statements in session. 3 SQL statements in session. ******************************************************************************** Trace file: billtest_ora_23964.trc Trace file compatibility: 10.01.00 Sort options: default 1 session in tracefile. 3 user SQL statements in trace file. 0 internal SQL statements in trace file. 3 SQL statements in trace file. 3 unique SQL statements in trace file. 53 lines in trace file. 54 elapsed seconds in trace file.