Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

understanding tkprof output

orausernAug 30 2010 — edited Aug 30 2010
Hi,

I have oracle 10.2.0.3 database on Solaris 8. For a batch insert application, following is part of tkprof output. In this I have some doubt in understanding it. The part of tkprof output is:
OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse    40000      3.48       3.17          0          0          0           0
Execute  40000     36.49      39.06          3      43364     860225       50174
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total    84914     39.97      42.23          3      43364     860225       50174

Elapsed times include waiting on following events:
  Event waited on                             Times   Max. Wait  Total Waited
  ----------------------------------------   Waited  ----------  ------------
  SQL*Net message to client                   42457        0.00          0.08
 SQL*Net message from client                 42457        1.40       1201.1 <--does this mean total wait of 12 seconds or of 1227 seconds?
My doubt is: the total wait is shown as 1201.1 - what does this statistics mean? Is it 1201.1 seconds? or is it 1201.1 hundredth or thousandth of a second?

I can't find the documentation link on interpretation of tkprof outpt which mentions the unit of time for "Total Waited". Will be thankful for the help.

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 27 2010
Added on Aug 30 2010
10 comments
6,889 views