Re: Excessive fetching

From: <Jared.Still_at_radisys.com>
Date: Fri, 7 May 2004 14:12:56 -0700
Message-ID: <OFCFD1043A.59D5057D-ON88256E8D.007474D2-88256E8D.00748B1E@radisys.com>

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_at_compgen.com>
Sent by: oracle-l-bounce_at_freelists.org
 05/07/2004 11:23 AM  

        To:     Oralce List <Oracle-L_at_freelists.org>
        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_at_freelists.org 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
-----------------------------------------------------------------

Received on Fri May 07 2004 - 16:10:19 CDT