RE: DB Links for Integration

  • From: "Taylor, Chris David" <ChrisDavid.Taylor@xxxxxxxxxxxxxxx>
  • To: "'dwarak.k@xxxxxxxxx'" <dwarak.k@xxxxxxxxx>, "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 9 Jan 2012 06:40:50 -0600

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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Dwaraknath Krishnamurthi
Sent: Sunday, January 08, 2012 3:25 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: DB Links for Integration


Here are my Questions


--
//www.freelists.org/webpage/oracle-l


Other related posts: