Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Can a query reuse data???
Oraboy wrote:
> I understand that data blocks are kept in the buffer cache but can
> someone clarify the following
>
> If i issue a query thats run before as well as avoiding a parse can
> Oracle make use of the previous result set or does it always go back
> and fetch the data from either the buffer cache or disk??
>
> Thanks
Results are always accurate to a point-in-time (SCN). How would a previously obtained result set meet this criterion?
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Tue Aug 01 2006 - 10:54:57 CDT