Oracle Streams vs Advanced Replication

From: David Turner <dnt9000_at_yahoo.com>
Date: Fri, 20 May 2005 14:45:05 -0700 (PDT)
Message-ID: <20050520214506.596.qmail@web30701.mail.mud.yahoo.com>

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.

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?

If so, what are do you like about Streams and what problems have you encountered using Streams?

I've also heard about people replicating using advanced queues and their own home grown utilties. If you're happy with what you're doing I'd like to hear about it.

I kind of feel like Oracle falls down on replication and would like to be proven wrong.

Thx, Dave                 

---

Do you Yahoo!?
Yahoo! Mail - Helps protect you from nasty viruses. http://promotions.yahoo.com/new_mail

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

Received on Fri May 20 2005 - 17:49:52 CDT