Hello,

i think there is a compoleir flag in Pro *C that controls the cursor
size, so you can reduce the no.of trips for each fetch from the
database defined by the dblink.

also, the driving table makes a HUGE difference when it comes to
distributed queries. I think there is a very good section in the Oracle
9i Performance Tuning Manual about Distributed Queries and tuning. Also
look in Metalink for some very good notes.

you may want to check the network utilisation on the network card that
is used for db link, see if you can use a private link across instead
of using a public network link. this will surely help.

ORA600