Re: Materialized Views Vs. Streams Replication
From: Shakespeare <whatsin_at_xs4all.nl>
Date: Fri, 12 Mar 2010 08:45:43 +0100
Message-ID: <4b99f13d$0$22934$e4fe514c_at_news.xs4all.nl>
Op 11-3-2010 18:12, Ora_DBA schreef:
> I have a questions for Oracle Gurus:
>
> We have a database that has about 70 tables. We need to replicate 32
> out of these 70 tables into another database. Both the source and the
> target database are Oracle 11gR1 and the OS is HP-Unix. The DB and the
> OS version is the same for both the source and the target database.
>
> Out of these 32 tables, about 10-15 are transaction tables. Remaining
> tables are lookup tables.
> The volume of records changed( Inserted/Updated/Deleted ) is about 1.5
> millions per day. There are no restrictions in implementing streams
> replication.
>
> Between Oracle Materialized Views with Fast Refresh option and Streams
> Replication, which is the less resource- intensive option for the
> replication ? Since we don't hace access to the production machine, we
> can't do any benchmarking now. Development machine is airtual machine
> wiyh less memory and less number of CPUs.
>
> From what I know, Oracle Materialized Views are less robust but easy
> to implement and Streams Replication is Robust but more complicated. I
> don't know how they compare performance wise.
>
> If you have any preference between the two options, plese let me know.
>
> Thanks in advance,
> - Sanjay
>
Date: Fri, 12 Mar 2010 08:45:43 +0100
Message-ID: <4b99f13d$0$22934$e4fe514c_at_news.xs4all.nl>
Op 11-3-2010 18:12, Ora_DBA schreef:
> I have a questions for Oracle Gurus:
>
> We have a database that has about 70 tables. We need to replicate 32
> out of these 70 tables into another database. Both the source and the
> target database are Oracle 11gR1 and the OS is HP-Unix. The DB and the
> OS version is the same for both the source and the target database.
>
> Out of these 32 tables, about 10-15 are transaction tables. Remaining
> tables are lookup tables.
> The volume of records changed( Inserted/Updated/Deleted ) is about 1.5
> millions per day. There are no restrictions in implementing streams
> replication.
>
> Between Oracle Materialized Views with Fast Refresh option and Streams
> Replication, which is the less resource- intensive option for the
> replication ? Since we don't hace access to the production machine, we
> can't do any benchmarking now. Development machine is airtual machine
> wiyh less memory and less number of CPUs.
>
> From what I know, Oracle Materialized Views are less robust but easy
> to implement and Streams Replication is Robust but more complicated. I
> don't know how they compare performance wise.
>
> If you have any preference between the two options, plese let me know.
>
> Thanks in advance,
> - Sanjay
>
Streams. And it is not (too) complicated (at least, when you are at 10.2 and up). It can be configured on a per table basis from within EM. But you need access to the source (= production) machine to configure streams. Unlike MV's, streams are initiated from the source, not the target database. To set up streams (IIRC) you need db-links both ways.
Shakespeare Received on Fri Mar 12 2010 - 01:45:43 CST