Re: Excessive fetching

From: Mike Chartier <mikec_at_compgen.com>
Date: Fri, 7 May 2004 14:23:23 -0400 (EDT)
Message-ID: <Pine.LNX.4.44.0405071416380.7064-100000@uxmikec.compgen.com>

>> 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

Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: 66  

-Mike

---

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 - 13:21:13 CDT