RE: Real time data trasfer between 2 DB

  • From: "Blanchard, William G" <William.Blanchard@xxxxxxxxxxxxx>
  • To: <Arvind.Kumar@xxxxxxxxxxxxx>, "rjamya" <rjamya@xxxxxxxxx>, <Richard.Goulet@xxxxxxxxxxx>
  • Date: Mon, 30 Aug 2010 15:06:14 -0500

My recommendation would be to just assign all of the reporting users to
a low consumer group.  This will ensure that your production users have
no impact and you can still get your reports out.





From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Arvind Kumar
Sent: Monday, August 30, 2010 12:30 AM
To: rjamya; Richard.Goulet@xxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: RE: Real time data trasfer between 2 DB


Dear All,


Many thanks for all your valuable suggestions. 

It seems if we keep a single DB for both purposes (records to be
inserted by GPS devices and for reporting) maintenance cost would be
less but we need to work out on database design and hardware cleverly.



Arvind Kumar



From: rjamya [mailto:rjamya@xxxxxxxxx] 
Sent: Friday, August 27, 2010 5:42 PM
To: Richard.Goulet@xxxxxxxxxxx
Cc: Arvind Kumar (IT-SIS-UIF); oracle-l@xxxxxxxxxxxxx
Subject: Re: Real time data trasfer between 2 DB


I agree with Dick, and would also add that tune the sqls for reporting
so they won't put additional load ... 


Also for replication, GoldenGate is another candidate ... you can do one
way replication but also consider the licensing costs etc.



On Fri, Aug 27, 2010 at 10:25 AM, Goulet, Richard
<Richard.Goulet@xxxxxxxxxxx> wrote:

First question I would ask is why do we have 2 databases in the first
place.  Mostly I get that requirement because "we don't want to impact
the activity of the application with reporting requirements"  In your
case the application is the bus sending data to the database for input,
not update.  And depending on your server the replication can become
more of a resource hog than the reporting.  I've got a situation like
that right now and it really is a bear.  So, get the right server with
more memory and cpu than you think you'll need for 10 years and have
just the single instance.  That also takes care of the latency issue as


Dick Goulet 
Senior Oracle DBA/NA Team Lead 
PAREXEL International 



The information contained in this message is proprietary and/or confidential. 
If you are not the intended recipient, please: (i) delete the message and all 
copies; (ii) do not disclose, distribute or use the message in any manner; and 
(iii) notify the sender immediately. In addition, please be aware that any 
message addressed to our domain is subject to archiving and review by persons 
other than the intended recipient. Thank you.

Other related posts: