David - I recently discussed this with an industry expert. Here is my note from that conversation: "Look at Oracle Streams, which uses Oracle's Advanced Queuing facility. This may be available in Standard Edition. The architecture is log-based, similar to Quest Shareplex. This means that it has no performance impact on the database being replicated from. Streams is a group of components that allow you to build your replication scheme, more of a kit. It is not proven in the real world yet. If your need is immediate, then avoid it, but if your need is next year, then investigate Streams. This is only available in Oracle9i." That is all I know, hope that helps.
Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -----Original Message----- Sent: Thursday, October 24, 2002 4:31 PM To: Multiple recipients of list ORACLE-L Has anyone started using the Oracle streams feature? I'm wondering how this compares to Advanced Rep. I am guessing this approach will provide better performance but thought I'd check with the list to see if someone can confirm this. Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Turner INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).