RE: DB Links for Integration
Date: Mon, 9 Jan 2012 06:40:50 -0600
Message-ID: <C5533BD628A9524496D63801704AE56D6ADB80B488_at_SPOBMEXC14.adprod.directory>
Technically yes. (The Oracle database link functionality will allow this)
> 1. What are the performance implications given a decent network? One
> interface would synchronize be 10,000 rows approximately. 70-80 interfaces
> can run at a time(meaning 80 different sources will be interfaced each with
> 10K records daily).
The answer is: "It depends."
Are the servers in the same data center physically, or are they spread across the world? A single 10,000 row insert is not very much - however, it is relative. A 10,000 row insert issued from/to Dual Quad-Core 3.0 Ghz Servers with disks striped across 200 spindles would be very, very, very fast. Likewise, a 10,000 row insert from a windows XP desktop, with a single hard drive running on a single core with anti-virus software would probably be much, much slower.
Also, take a look at the /*+ APPEND */ hint which can help insert performance.
> 1. Are there any other important factors to consider.
What are the disk IO benchmarks, technical layouts (spindles, RAID levels etc) for all servers involved? On the destination database, it would be wise to have the TABLESPACES broken down into multiple data files. If you have multiple LUNS (not sharing the same disks) then it would be better to also have the datafiles on for each tablespace on different LUNS. If all LUNs share the same disks then there may still be some benefit to having datafiles on different LUNs as some OS's will still be able to open more channels for writing if the writes are going to different LUNs. (Perhaps this is true for all operating systems - not sure)
Chris Taylor
Sr. Oracle DBA
Ingram Barge Company
Nashville, TN 37205
"Quality is never an accident; it is always the result of intelligent effort." -- John Ruskin (English Writer 1819-1900)
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Dwaraknath Krishnamurthi
Sent: Sunday, January 08, 2012 3:25 AM
To: oracle-l_at_freelists.org
Subject: DB Links for Integration
Here are my Questions
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Jan 09 2012 - 06:40:50 CST