perf tuning

[quester]

I could be wrong, but I think the way it works is -

When Oracle Executes the Cursor Statement, it will PARSE (if it is not already) and load "all" the data into the SGA as defined by the cursor - and the "Internal Cursor Pointer" points to the First Row in the Data Set.

The "Fetch" process moves the data into the Cursor Variable, each time the Pointer moves to the next record within the data set. So I think, it doesn't go through the remote database for each fetch, but only once to load the data into the SGA.



PS: It would be nice if someone confirmed my contention.