Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Tkprof result reading

Re: Tkprof result reading

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 25 Jun 2001 19:04:25 -0700
Message-ID: <9h8qj902e47@drn.newsguy.com>

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 Corp 
Received on Mon Jun 25 2001 - 21:04:25 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US