Re: Excessive fetching

Thanks Mike.
That is however the output from tkprof.

A few lines (20 or so) from the trace file would be more informative.

Jared






Mike Chartier <mikec@xxxxxxxxxxx>
Sent by: oracle-l-bounce@xxxxxxxxxxxxx
 05/07/2004 11:23 AM


 
        To:     Oralce List <Oracle-L@xxxxxxxxxxxxx>
        cc: 
        Subject:        Re: Excessive fetching
>> Now when a run a 10046 level 12 trace on my test program (which does 
1000 
>> such inserts) I see that it executes the SELECT 1000 times but fetches 
>> 2000.

>Mike,
>
> I don't know the answer to your question, but I would like to
> see a snippet of the trace file showing the extra fetches.
>
> Jared

Here's the snipet:

SELECT my_clob
FROM
 my_table WHERE id = :1 FOR UPDATE
 
 
call     count       cpu    elapsed       disk      query    current  rows
 ------- ------  -------- ---------- ---------- ---------- ---------- 
----------
Parse        1      0.00       0.00          0          0          0     0
Execute   1000      0.44       0.33          0       3000       1000     0
Fetch     2000      0.08       0.16          0       3000          0  1000
------- ------  -------- ---------- ---------- ---------- ---------- 
----------
total     3001      0.52       0.50          0       6000       1000  1000 





----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: