Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Excessive fetching
This is probably classic implicit cursor fetch .... In implicit cursor,
oracle performs a second fetch to see if it can raise TOO_MANY_ROWS
exception.
I *could* be wrong, but ...
Raj
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of
Jared.Still_at_radisys.com
Sent: Thursday, May 06, 2004 2:30 PM
To: oracle-l_at_freelists.org
Subject: Re: Excessive fetching
> Now when a run a 10046 level 12 trace on my test program (which does
1000=20
> 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
-- 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 Thu May 06 2004 - 13:47:58 CDT
![]() |
![]() |