Home » RDBMS Server » Performance Tuning » database links question (oracle 11g)
database links question [message #598415] Mon, 14 October 2013 10:54 Go to next message
manoj12
Messages: 210
Registered: March 2008
Location: India
Senior Member
Hi Sir,

I need an answer to this question?

A website requires to display consolidated data from databases located in different geographical regions (India, London and New York). The application server for the website is hosted only in one location India. What are the techniques that can be used for faster retrieval of data from all 3 databases?
Note: There is no need of real time data retrieval from different regions; however the user should able to view the updated data at predefined intervals.


Appreciate your help.?
Re: database links question [message #598418 is a reply to message #598415] Mon, 14 October 2013 11:00 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>What are the techniques that can be used for faster retrieval of data from all 3 databases?
faster than container ship?
How much data needs to be moved across the network?
What is the available network bandwidth between the sites?
icon10.gif  Re: database links question [message #598419 is a reply to message #598415] Mon, 14 October 2013 11:02 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
I need an answer to this question?


No. Grin

Have a look at the different replication mechanisms you can find in the documentation: mviews, Streams, CDC...


Re: database links question [message #598423 is a reply to message #598415] Mon, 14 October 2013 11:11 Go to previous messageGo to next message
manoj12
Messages: 210
Registered: March 2008
Location: India
Senior Member
But Lets say say there is no network issue at all.what could be the problem
Re: database links question [message #598424 is a reply to message #598423] Mon, 14 October 2013 11:12 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
manoj12 wrote on Mon, 14 October 2013 21:41
But Lets say say there is no network issue at all.what could be the problem


What are the troubleshooting steps you implemented? There is no general rule or documented steps to come to a conclusion.
Re: database links question [message #598426 is a reply to message #598424] Mon, 14 October 2013 11:18 Go to previous messageGo to next message
manoj12
Messages: 210
Registered: March 2008
Location: India
Senior Member
does materialized views really help?
Re: database links question [message #598429 is a reply to message #598426] Mon, 14 October 2013 11:42 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>does materialized views really help?
yes, no, maybe, it depends upon what specific problem needs to be solved.
Previous Topic: Force the optimizer to consider all join permutations
Next Topic: Insert data fast on table
Goto Forum:
  


Current Time: Thu Mar 28 12:05:49 CDT 2024