Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Streams

Re: Streams

From: Tim Gorman <Tim_at_SageLogix.com>
Date: Thu, 24 Oct 2002 15:00:53 -0800
Message-ID: <F001.004F3400.20021024150053@fatcity.com>


The statement about "no performance impact on the database being replicated from" may not be entirely accurate. In order to work, Oracle Streams (which uses Log Miner) needs "supplemental" redo data to be generated by the originating system, resulting from the ALTER DATABASE ADD SUPPLEMENTAL LOG DATA [ [ PRIMARY | UNIQUE ] KEY COLUMNS ] command. This causes additional data to be sent to the redo log stream when updates occur. I'm not certain exactly what level of supplemental log data is needed by Oracle Streams (if any), but perhaps someone else on the list can help with that?

> 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.
> dwilliams_at_lifetouch.com
>
>
> -----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: turner_at_tellme.com
>
> 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: ListGuru_at_fatcity.com (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: DWILLIAMS_at_LIFETOUCH.COM
>
> 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: ListGuru_at_fatcity.com (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: Tim Gorman
  INET: Tim_at_SageLogix.com

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: ListGuru_at_fatcity.com (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).
Received on Thu Oct 24 2002 - 18:00:53 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US