Re: Oracle Streams vs Advanced Replication

From: Sami Seerangan <dba.orcl_at_gmail.com>
Date: Sun, 22 May 2005 22:50:52 -0400
Message-ID: <f09dd62805052219505c3f3ea6@mail.gmail.com>

Dave,

We have both Streams and Adv. replication implemented, each has its own iss= ues.
Recently we implemented Quest Shareplex too (just for migration purpose) Ask yourself these questions before you decide between these two.

1)What kind of replication you are taking about?=20 Uni-directional or Bi-directional
Synchronous or Asynchronous

2) Do you update the same data in more than one database? hot-hot or hot-warm(like primary and DR site kind of)

3)What is the Oracle version you will be using to implement this solution? I heard 10g streams are much better compare to 9i. We do have some issues with 9i streams (like runaway process,etc where the capture process is running)

4) Are you going to implement this in clustered environment? If you are using 9i streams, it cannot mine redo logs. It can mine only archive redo logs.

5)How ofter you will be making structural changes to replicated objects? If you are using OAR, you have quiesce the database group where you are making structural changes. All the replication sites are NOT available for DML changes for that replication group.

Regards,
Sami

On 5/20/05, David Turner <dnt9000_at_yahoo.com> wrote:
> I'm working on a project that will use Oracle with
> some type of replication, either at the application
> layer, using advanced rep, or Oracle Streams.

>=20

> I've heard Advanaced Rep is resource intensive and
> often slow to propagate changes at high volumes of
> transactions. Is there anyone out there using Oracle
> Streams in a production environment with transaction
> rates approaching 300 inserts a second?

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

Received on Sun May 22 2005 - 22:55:37 CDT