Hi

well imagine that your remote table contains a million rows..so will the cursor fetch million rows and insert it into the local buffer cache nope..this is not true..it will return the first rows as quickly as possible..if your using sqlplus for the above operation try varying the arraysize parameter and look what happens..there would be a point of diminishing return where you need to stop altering your array size

regards
Hrishy