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 <richard.ji_at_mobilespring.com> 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: treegarden_at_yahoo.com
>
> 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: ListGuru_at_fatcity.com (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: richard.ji_at_mobilespring.com
>
> 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: ListGuru_at_fatcity.com (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: treegarden_at_yahoo.com
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: ListGuru_at_fatcity.com (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).
Received on Thu Feb 06 2003 - 17:28:52 CST
