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
about this message, contact [EMAIL PROTECTED] for clarification.
ORA47371.prf
