Home » SQL & PL/SQL » SQL & PL/SQL » dblink (oracle 10g)
icon10.gif  dblink [message #419582] Mon, 24 August 2009 06:28 Go to next message
tcsdba
Messages: 6
Registered: July 2009
Junior Member
Hi Experts!!!!
Can anyone tell me what is the maximum limit of data that can be transfered through dblink between 2 databases. my databases are of size 40 gb , and the data transfer will be about 50,000 mb per day.. with peak 1000mb/sec

thanks Laughing
Re: dblink [message #419583 is a reply to message #419582] Mon, 24 August 2009 06:32 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No limit per Oracle but it is likely you don't use the more appropriate solution.

Regards
Michel
Re: dblink [message #419588 is a reply to message #419582] Mon, 24 August 2009 06:52 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
It depends entirely on the network sped between the two boxes.

If your Dbs are 40Gb, how/why are you transfering 50Gb/day between them?
Can you not stick both systems in the same database?
Previous Topic: Row to Column
Next Topic: Performabce tuning in SQL
Goto Forum:
  


Current Time: Sat Dec 10 20:34:41 CST 2016

Total time taken to generate the page: 0.10032 seconds