From: Ora_DBA on
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

From: ddf on
On Mar 11, 12:12 pm, Ora_DBA <sanjaydharmadhik...(a)gmail.com> wrote:
> 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

I've seen better performance with Streams than with Materialized Views
since Streams is using logminer to generate the statements to apply
changes.

My two cents.


David Fitzjarrell
From: Shakespeare on
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
From: Frank van Bortel on
Ora_DBA wrote:
> 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
>

As usual: it depends.

MV's as well as Streams are valid options. Just test and see what
fits your exact scenario best.

I've seem Streams crumble and crash under load, but that was in an
earlier version.

--

Regards, Frank van Bortel

Topposting in Usenet groups I regard as offensive - I will not reply