TKPROF: Release 11.2.0.1.0 - Development on Fri Dec 21 15:37:11 2012 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. Trace file: orcl2_ora_2946.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 -------------------------------------------------------------------------------- *** SESSION ID:(22.857) 2012-12-19 18:54:47.897 ******************************************************************************** select count(pad) from test 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 2 0.77 0.77 0 17874 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.77 0.77 0 17874 0 1 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 90 Rows Row Source Operation ------- --------------------------------------------------- 1 SORT AGGREGATE (cr=17874 pr=0 pw=0 time=779212 us) 10000000 TABLE ACCESS FULL TEST (cr=17874 pr=0 pw=0 time=3321542 us cost=5022 size=20000000 card=10000000) ******************************************************************************** select count(pad) from test 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 2 0.65 0.65 0 17874 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.65 0.65 0 17874 0 1 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 90 Rows Row Source Operation ------- --------------------------------------------------- 1 SORT AGGREGATE (cr=17874 pr=0 pw=0 time=653516 us) 10000000 TABLE ACCESS FULL TEST (cr=17874 pr=0 pw=0 time=3134875 us cost=5022 size=20000000 card=10000000) ******************************************************************************** select count(pad) from test 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 2 0.57 0.57 0 17874 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.57 0.57 0 17874 0 1 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 90 Rows Row Source Operation ------- --------------------------------------------------- 1 SORT AGGREGATE (cr=17874 pr=0 pw=0 time=0 us) 10000000 TABLE ACCESS FULL TEST (cr=17874 pr=0 pw=0 time=0 us cost=5022 size=20000000 card=10000000) ******************************************************************************** select count(pad) from test 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 2 0.64 0.62 0 17874 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.64 0.62 0 17874 0 1 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 90 Rows Row Source Operation ------- --------------------------------------------------- 1 SORT AGGREGATE (cr=17874 pr=0 pw=0 time=629517 us) 10000000 TABLE ACCESS FULL TEST (cr=17874 pr=0 pw=0 time=3147466 us cost=5022 size=20000000 card=10000000) ******************************************************************************** select count(pad) from test 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 2 1.02 1.02 0 17874 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 1.02 1.02 0 17874 0 1 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 90 Rows Row Source Operation ------- --------------------------------------------------- 1 SORT AGGREGATE (cr=17874 pr=0 pw=0 time=1029145 us) 10000000 TABLE ACCESS FULL TEST (cr=17874 pr=0 pw=0 time=3250734 us cost=5022 size=20000000 card=10000000) ******************************************************************************** select count(pad) from test 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 2 1.32 1.31 0 17874 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 1.32 1.31 0 17874 0 1 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 90 Rows Row Source Operation ------- --------------------------------------------------- 1 SORT AGGREGATE (cr=17874 pr=0 pw=0 time=1316173 us) 10000000 TABLE ACCESS FULL TEST (cr=17874 pr=0 pw=0 time=3098247 us cost=5022 size=20000000 card=10000000) ******************************************************************************** select count(pad) from test 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 2 2.02 2.02 0 17874 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 2.02 2.02 0 17874 0 1 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 90 Rows Row Source Operation ------- --------------------------------------------------- 1 SORT AGGREGATE (cr=17874 pr=0 pw=0 time=2023179 us) 10000000 TABLE ACCESS FULL TEST (cr=17874 pr=0 pw=0 time=3123804 us cost=5022 size=20000000 card=10000000) ******************************************************************************** select count(pad) from test 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 2 3.41 3.41 0 17874 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 3.41 3.41 0 17874 0 1 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 90 Rows Row Source Operation ------- --------------------------------------------------- 1 SORT AGGREGATE (cr=17874 pr=0 pw=0 time=3411088 us) 10000000 TABLE ACCESS FULL TEST (cr=17874 pr=0 pw=0 time=3141762 us cost=5022 size=20000000 card=10000000) ******************************************************************************** select count(pad) from test 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 2 6.28 6.28 0 17874 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 6.28 6.28 0 17874 0 1 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 90 Rows Row Source Operation ------- --------------------------------------------------- 1 SORT AGGREGATE (cr=17874 pr=0 pw=0 time=6287226 us) 10000000 TABLE ACCESS FULL TEST (cr=17874 pr=0 pw=0 time=3356391 us cost=5022 size=20000000 card=10000000) ******************************************************************************** OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 9 0.00 0.00 0 0 0 0 Fetch 18 16.68 16.70 0 160866 0 9 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 27 16.68 16.70 0 160866 0 9 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 9 user SQL statements in session. 0 internal SQL statements in session. 9 SQL statements in session. ******************************************************************************** Trace file: orcl2_ora_2946.trc Trace file compatibility: 11.1.0.7 Sort options: default 1 session in tracefile. 9 user SQL statements in trace file. 0 internal SQL statements in trace file. 9 SQL statements in trace file. 1 unique SQL statements in trace file. 139 lines in trace file. 17 elapsed seconds in trace file.