TKPROF: Release 10.2.0.4.0 - Production on Fri Mar 27 22:25:49 2009
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Trace file: mig_ora_15557.trc
Sort options: execpu
********************************************************************************
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 rnum, b.object_name, object_id, owner
from testtrc.testtrc a, testtrc.test_master b
where a.object_name = b.object_name
and b.owner = 'SYS'
union
select sum(rnum), min(b.object_name), avg(object_id), max(owner)
from testtrc.testtrc a, testtrc.test_master b
where a.object_name = b.object_name
order by 4,1,3,2 desc
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.01 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 3 0.00 0.03 0 47 0 30
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 5 0.00 0.05 0 47 0 30
Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: 73 (TESTTRC)
Rows Row Source Operation
------- ---------------------------------------------------
30 SORT UNIQUE (cr=47 pr=0 pw=0 time=33529 us)
30 UNION-ALL (cr=47 pr=0 pw=0 time=2237 us)
29 HASH JOIN (cr=23 pr=0 pw=0 time=1910 us)
12 TABLE ACCESS BY INDEX ROWID TEST_MASTER (cr=2 pr=0 pw=0 time=218 us)
12 INDEX RANGE SCAN IDX_MASTER (cr=1 pr=0 pw=0 time=45 us)(object id 35438)
4785 TABLE ACCESS FULL TESTTRC (cr=21 pr=0 pw=0 time=9632 us)
1 SORT AGGREGATE (cr=24 pr=0 pw=0 time=3172 us)
80 HASH JOIN (cr=24 pr=0 pw=0 time=1084 us)
46 TABLE ACCESS FULL TEST_MASTER (cr=3 pr=0 pw=0 time=164 us)
4785 TABLE ACCESS FULL TESTTRC (cr=21 pr=0 pw=0 time=9590 us)
Rows Execution Plan
------- ---------------------------------------------------
0 SELECT STATEMENT MODE: ALL_ROWS
30 SORT (UNIQUE)
30 UNION-ALL
29 HASH JOIN
12 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF
'TEST_MASTER' (TABLE)
12 INDEX MODE: ANALYZED (RANGE SCAN) OF 'IDX_MASTER'
(INDEX)
4785 TABLE ACCESS MODE: ANALYZED (FULL) OF 'TESTTRC' (TABLE)
1 SORT (AGGREGATE)
80 HASH JOIN
46 TABLE ACCESS MODE: ANALYZED (FULL) OF 'TEST_MASTER'
(TABLE)
4785 TABLE ACCESS MODE: ANALYZED (FULL) OF 'TESTTRC' (TABLE)
********************************************************************************
OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.01 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 3 0.00 0.03 0 47 0 30
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 5 0.00 0.05 0 47 0 30
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
1 user SQL statements in session.
0 internal SQL statements in session.
1 SQL statements in session.
1 statement EXPLAINed in this session.
********************************************************************************
Trace file: mig_ora_15557.trc
Trace file compatibility: 10.01.00
Sort options: execpu
1 session in tracefile.
1 user SQL statements in trace file.
0 internal SQL statements in trace file.
1 SQL statements in trace file.
1 unique SQL statements in trace file.
1 SQL statements EXPLAINed using schema:
TESTTRC.prof$plan_table
Default table was used.
Table was created.
Table was dropped.
47 lines in trace file.
0 elapsed seconds in trace file.