Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Size Of Active Set prior to Fetch
On Thu, 4 Sep 1997 13:33:07 GMT, Michael.Wallach_at_GSC.GTE.Com (North Carolina Systems Center) wrote:
>Is there any way to determine the size of the active set created by an
>Open before doing a Fetch in PL/SQL or through an OCI call?
>
>Mike
No there isn't. In most cases, the size of the active set is not known until the last row is actually fetched. For example, if I have a 10,000,000 row table T and issue "select * from T", the first N rows come back immediately, oracle doesn't pre-fetch and copy all matching rows. We won't know until we are done how many there were...
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Bethesda MD
http://govt.us.oracle.com/ -- downloadable utilities