Search the web
Sign In
New User? Sign Up
OraTechSupportGroup · Oracle Techniques Discussion Group
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Show off your group to the world. Share a photo of your group with us.

Best of Y! Groups

   Check them out and nominate your group.
Having problems with message search? Fill out this form to ensure your group is one of the first to be migrated to the new message search system.

Messages

  Messages Help
Advanced
Oracle Database Links   Message List  
Reply | Forward Message #441 of 457 |


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









Wed Nov 3, 2004 7:47 am

dayananda_in
Offline Offline
Send Email Send Email

Forward
Message #441 of 457 |
Expand Messages Author Sort by Date

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...
dayananda_in
Offline Send Email
Nov 11, 2004
9:50 pm

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. ...
Rajesh Arora
arora_rajesh@...
Send Email
Nov 11, 2004
11:11 pm

Hi, Following Outerjoin Query, when used RULE based, gives exact result, when COST base is used giving Inconsistant result. SQL> desc IACLINK Name Type...
dayananda shenoy
dayananda_in
Offline Send Email
Nov 13, 2004
4:37 pm

I agree with Rajesh Arora if you can use hints that will be good enough. Also, if you can effort you can make a table in your local database, so that the...
Sunil
sunilbhola
Offline Send Email
Dec 23, 2004
3:37 am

Hi How to check the Database patch( using opatch or oui) whether it is applied or not. with regards Subrahmanyeswara Rao ... Do you Yahoo!? Dress up your...
p k s subrahmanyeswar...
bpkssrao@...
Send Email
Dec 23, 2004
4:54 am

To check O/S Patches: HP $ /usr/sbin/swlist -l patch Linux $ rpm -qa Solaris 64-bit $ showrev -p For Database Patches: $ cd $ORACLE_HOME/bin $ owhat oracle ......
sunil bhola
sunilbhola
Offline Send Email
Dec 23, 2004
2:34 pm
Advanced

Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help