TKPROF output, what is this?
hi, I have traced a users session (they complain about performance) but I dont really get the output from the trace file:
select order_no
from
ordhead where status in( 'A','C')
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 49 0.00 0.00 0 0 0 0
Execute 49 0.00 0.00 0 0 0 0
Fetch 29827 3.35 4.93 92442 121493 0 2978546
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 29925 3.36 4.94 92442 121493 0 2978546
Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: 145
Rows Row Source Operation
------- ---------------------------------------------------
141831 TABLE ACCESS FULL ORDHEAD (cr=5782 pr=4402 pw=0 time=112976 us cost=1227 size=992334 card=141762)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
select order_no
from
ordhead where status in( 'A','C')
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 49 0.00 0.00 0 0 0 0
Execute 49 0.00 0.00 0 0 0 0
Fetch 29827 3.35 4.93 92442 121493 0 2978546
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 29925 3.36 4.94 92442 121493 0 2978546
Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: 145
Rows Row Source Operation
------- ---------------------------------------------------
141831 TABLE ACCESS FULL ORDHEAD (cr=5782 pr=4402 pw=0 time=112976 us cost=1227 size=992334 card=141762)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
0