Hi All,

I have a PL/SQL application. The code looks like:

open a_cur for
select a_column from a_table@a_remote_database;
loop
fetch a_cur into a_variable;
exit when a_cur%notfound;
-- process other stuff locally including inserts, etc...
end loop;

My questions are:
1. Does each fetch grab A row from a_remote_database,
or Oracle fetch ALL the data into local SGA?
2. If each fetch will be through Net, how can I tune
this application?

Thank you!