mis-matching between tkprof output and its raw input

From: Danisment UNAL <danisment_at_yahoo.com>
Date: Wed, 31 Jan 2001 03:59:04 -0800
Message-ID: <F001.002A576D.20010131040040@fatcity.com>

Hi,

I'm using po816 for windows98. I saw some mis-matchings between sql_trace raw file and tkprof output.

For PARSE phase of attached sample:

elapsed time (e=264) = 2.64 sec. --- tkprof shows 1.56 sec
CR reads (cr=4) = 4 --- tkprof shows 0

does Oracle just read raw file and generate output file ? or is there a computation by tkprof ?

thanks in advance...

*********raw file**********

PARSING IN CURSOR #1 len=12 dep=0 uid=5 oct=7 lid=5 tim=1236815 hv=3307652681 ad='318ae70'
delete test
END OF STMT
PARSE
#1:c=0,e=264,p=0,cr=4,cu=0,mis=1,r=0,dep=0,og=4,tim=1236816
EXEC
#1:c=0,e=266,p=0,cr=4,cu=565,mis=0,r=500,dep=0,og=4,tim=1237082
STAT #1 id=1 cnt=1 pid=0 pos=0 obj=0 op='DELETE TEST ' STAT #1 id=2 cnt=501 pid=1 pos=1 obj=3011 op='TABLE ACCESS FULL TEST ' *********tkprof output**********

delete test

call     count       cpu    elapsed       disk     
query    current        rows

------- ------ -------- ---------- ---------- ---------- ---------- ----------

Parse        1      0.00       1.56          0        
 0          0           0
Execute      1      0.00       2.66          0        
 4        565         500
Fetch        0      0.00       0.00          0        
 0          0           0

------- ------ -------- ---------- ---------- ---------- ---------- ----------

total        2      0.00       4.22          0        
 4        565         500

Danisment Gazi Unal
Web: http://www.geocities.com/danisment

Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ Ora47371.trc

The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail.

This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions

Received on Wed Jan 31 2001 - 05:59:04 CST