Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Tkprof result reading
In article <9h8q7g02cr6_at_drn.newsguy.com>, Thomas says...
>
>In article <bd9a9a76.0106251145.76ff5220_at_posting.google.com>, bchorng_at_yahoo.com
>says...
>>
>>I know "query" column in the tkprof output means buffer gets. But I don't know
>>the difference between execute and fetch. Can someone please explain it ? And
>>why would my elapsed time smaller than CPU time in this case ?
>>
>>Here is an example:
>>
>>call count cpu elapsed disk query current rows
>>------- ------ -------- ---------- ---------- ---------- ---------- ----------
>>Parse 1 0.02 0.00 0 0 0 0
>>Execute 3003 0.88 0.70 3 30030 0 0
>>Fetch 3003 0.13 0.20 2 3003 12012 3003
>>------- ------ -------- ---------- ---------- ---------- ---------- ----------
>>total 6007 1.03 0.90 5 33033 12012 3003
>>
>>Can someone explain the difference between execute (30030) and fetch (300)
>>in this case and what exactly do they mean ?
>
>well, technically speaking the different is we did 100 times the logical IO
>during the execute phase then we did during the fetch phase.
woops -- meant 10 times.
-- Thomas Kyte (tkyte@us.oracle.com) http://asktom.oracle.com/ Expert one on one Oracle, programming techniques and solutions for Oracle. http://www.amazon.com/exec/obidos/ASIN/1861004826/ Opinions are mine and do not necessarily reflect those of Oracle CorpReceived on Mon Jun 25 2001 - 21:04:25 CDT