Re: Excessive fetching

  • From: Mike Chartier <mikec@xxxxxxxxxxx>
  • To: Oralce List <Oracle-L@xxxxxxxxxxxxx>
  • Date: Fri, 7 May 2004 14:23:23 -0400 (EDT)

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