RE: Does EXEC do a FETCH?

  • From: "Henry Poras" <henry@xxxxxxxxxxxxxxx>
  • To: "'Allen, Brandon'" <Brandon.Allen@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 13 Jul 2007 16:22:05 -0400

Possibly, but do you know if prefetching is turned on by default in sqlplus?
Also, that still doesn't explain what the FETCH r=1 does, as the record has
already been (pre)fetched. It still looks like the order displayed in the
10046 trace is not the order of events as they actually occur.


> -----Original Message-----
> From: Allen, Brandon [mailto:Brandon.Allen@xxxxxxxxxxx] 
> Sent: Friday, July 13, 2007 4:08 PM
> To: henry@xxxxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
> Subject: RE: Does EXEC do a FETCH?
> Sounds like prefetching at work - I think it has been on by default
> since 8i or 9i:
> /oci04sql.
> htm#428255
> Privileged/Confidential Information may be contained in this 
> message or attachments hereto. Please advise immediately if 
> you or your employer do not consent to Internet email for 
> messages of this kind. Opinions, conclusions and other 
> information in this message that do not relate to the 
> official business of this company shall be understood as 
> neither given nor endorsed by it.


Other related posts: