RE: Oracle Streams
Date: Fri, 3 Feb 2012 11:51:02 -0500
Message-ID: <304F58144267C5439E733532ABC9A3A1140399CA_at_USA0300MS02.na.xerox.net>
We are running Oracle Streams where we are streaming selective tables from four different Oracle ERP systems geographically located at different locations (US, EU). Tables are getting streamed to a central database. What we seen is that:
- Streams APPLY will need to be tune to get a good performance. Initially we had issues with the APPLY speed but once APPLY was tuned, tables are staying in synch most of the time. - The main issue is with the long running transactions where we have seen that APPLY lags behind by several hours on large spilled transactions. According to Oracle, this is a limitation of Streams and the solution is to run those batch jobs directly against the APPLY database.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Guillermo Alan Bort
Sent: Friday, February 03, 2012 11:38 AM
To: regdba_at_yahoo.com
Cc: Oracle-l
Subject: Re: Oracle Streams
You can try GoldenGate (though I've had some problems with it) or look
into
Active DataGuard (which is a pretty expensive option)
There's also the posibility of using MViews on a DB Link if you have a
stable and private link between the two sites... I have seen this
working
several years ago, on 9i databases. I think they called it advanced
replication or something like that. It's a lot of work to set up, but
once
it's there it's pretty easy to maintain. And the 10g scheduler is far
better than the dbms_jobs that 9i had for scheduling the refresh
operations.
hth
Cheers
Alan.-
On Fri, Feb 3, 2012 at 12:48 PM, Peter Barnett <regdba_at_yahoo.com> wrote:
> We are looking at keeping a remote database at a vendor site updated.
> Timing is not terribly critical since one of the options is running a
> batch ETL job on a daily basis.
>
> Another option is to use Oracle Streams. Our previous experience with
> this product has not been very positive but that has been several
years
> ago. It was high maintenance for the DBA and we had a problem on the
> target server maintaining RI without disabling a lot of triggers.
>
> Given the choices, has Streams improved enough to reconsider it?
>
> Pete Barnett
> Database Technologies Lead
> Cambia Health Solutions
> peter.barnett_at_cambiahealth.com
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Fri Feb 03 2012 - 10:51:02 CST