Hi Dayananda,

There are hints , which you can use to run part of the sql on remote site ,
decreasing cpu utilization on your local database & split the load.

"driving_site" is one hint I know can do this.

Regards,
Rajesh Arora


The information contained in this transmission may contain privileged and
confidential information. It is intended only for the use of the person(s)
named above. If you are not the intended recipient, you are hereby notified
that any review, dissemination, distribution or duplication of this
communication is strictly prohibited. If you are not the intended recipient,
please contact the sender by reply email immediately and destroy all copies
of the original message.



----Original Message Follows----
From: "dayananda_in" <dayananda_in@...>
Reply-To: OraTechSupportGroup@yahoogroups.com
To: OraTechSupportGroup@yahoogroups.com
Subject: [OraTechSupportGroup] Oracle Database Links
Date: Wed, 03 Nov 2004 07:47:23 -0000



Hi,
my name is dayananda shenoy, i am working as an vb/oracle developer.
currently we are developing a large scale centralised banking
software in vb and oracle.
our application has to handle many independent oracle databases.
currently we are using oracle dblinks for accessing remote data.
we are observing that cpu utilisation goes to maximum when we query
against dblinks.
is there any parameters or efficiant way of fetching data from
distributed databases

thanks in advace

dayananda shenoy.k

_________________________________________________________________
The all-new MSN Mesenger! Get the coolest emoticons.
http://server1.msn.co.in/sp04/messengerchat/ Share more of yourself!