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