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.
Henry
> -----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:
>
> http://download.oracle.com/docs/cd/B10501_01/appdev.920/a96584
> /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.
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
