Re: Perhaps a _REALLY_ dumb question from an experienced dba?
From: rjamya <rjamya_at_gmail.com>
Date: Thu, 8 Aug 2013 15:24:41 -0400
Message-ID: <CAGurbTMZsyYGu-z1xvDEKNqLHyFw7=5Fwk+B5jVs5ZggMAv7ow_at_mail.gmail.com>
I'd say, FETCH follows the execution plan decided, fetches ARRAYSIZE worth of rows, returns them to client, once gets ack that those have been received, it fetches next set until it is all done. I dont think result set is built, just the path is pre-built for fetch to follow (until you use 12c).
I am sure Tanel has done some truss/stract/dtrace and prove that :)
Date: Thu, 8 Aug 2013 15:24:41 -0400
Message-ID: <CAGurbTMZsyYGu-z1xvDEKNqLHyFw7=5Fwk+B5jVs5ZggMAv7ow_at_mail.gmail.com>
I'd say, FETCH follows the execution plan decided, fetches ARRAYSIZE worth of rows, returns them to client, once gets ack that those have been received, it fetches next set until it is all done. I dont think result set is built, just the path is pre-built for fetch to follow (until you use 12c).
I am sure Tanel has done some truss/stract/dtrace and prove that :)
I could be wrong, but that is how understand it.
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Aug 08 2013 - 21:24:41 CEST