? ? ? ? 7 4 7 INDEX RANGE SCAN I_ACCESS1 (cr=6 pr=0 pw=0 time=48 us cost=2 size=0 card=7)(object id 108)
********************************************************************************
OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 3 0.00 0.00 0 0 0 0
Execute 4 0.01 0.01 0 0 0 1
Fetch 4 0.01 0.01 0 0 0 2
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 11 0.02 0.03 0 0 0 3
Misses in library cache during parse: 3
Misses in library cache during execute: 2
OVERALL TOTALS FOR ALL RECURSIVE STATEMENTS
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 27 0.03 0.03 0 0 0 0
Execute 61 0.01 0.02 0 0 0 0
Fetch 133 0.01 0.02 6 286 0 103
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 221 0.06 0.08 6 286 0 103
Misses in library cache during parse: 16
Misses in library cache during execute: 15
? ? 4 user SQL statements in session.
? 27 internal SQL statements in session.
? 31 SQL statements in session.
********************************************************************************
Trace file: HOEGH_ora_16427.trc
Trace file compatibility: 11.1.0.7
Sort options: default
? ? ? 1 session in tracefile.
? ? ? 4 user SQL statements in trace file.
? ? ? 27 internal SQL statements in trace file.
? ? ? 31 SQL statements in trace file.
? ? ? 20 unique SQL statements in trace file.
? ? 534 lines in trace file.
? ? 337 elapsed seconds in trace file.