That's what I was looking for, thanks. I understood that state information was preserved (after all, one could fetch one row an hour), but I didn't know how/where. I guess the cursor contains information on the last step executed of the optimizer plan.
--- Richard Ji <[EMAIL PROTECTED]> wrote: > Stole right from asktom. Thanks Tom. :) > > We do not build the result set anywhere in general. > > If you do select * from one_billion_row_table -- we fetch the data > from the > table as needed -- the results start coming back IMMEDIATELY not > after we've > fetched the last row. > > For certain types of queries we might build part of the result set or > all of > it > (depends). This would take place in RAM upto sort_area_size bytes > and then > we > would start paging that out to TEMP. > > We find rows 100 to 115 by maintaining a state, called a cursor, on > the > server. > It tells us where we left off and where to begin. > > Richard Ji > > -----Original Message----- > Sent: Wednesday, February 05, 2003 12:35 PM > To: Multiple recipients of list ORACLE-L > > > When one executes a query, the result set is identified. Fetching > the > rows in the result set can be done over a period of time. In what > form > does Oracle maintain the result set, and where? > > TIA > > Paul Baumgartel > > > __________________________________________________ > Do you Yahoo!? > Yahoo! Mail Plus - Powerful. Affordable. Sign up now. > http://mailplus.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Paul Baumgartel > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Richard Ji > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
