Re: reduce dblink (database link) chatter

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 Received on Mon Aug 01 2005 - 22:39:41 CDT