Re: Excessive fetching
- From: Jared.Still@xxxxxxxxxxx
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 7 May 2004 14:12:56 -0700
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 //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
