Database Utilities (MOSC)

MOSC Banner

TKPROF output, what is this?

edited Feb 17, 2012 2:44AM in Database Utilities (MOSC) 5 commentsAnswered
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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center