RE: Parallel Replication of Single Table

Waleed,

Initiated from the target side. Parallel DML is enabled with an alter session. And you know it's using parallelism by watching the sessions spawned off on each side, the work they are doing, and the PQ stats.

Another member of the list I work with (a darn genius I tell you, with a mind that never forgets anything, never forgetting any nuance or issue ;-) ) spent a little time this afternoon ripping 230 million rows from a large dimension across the db's. That was the workaround because the standard replication "as is" just couldn't handle the recent increase in the volume of changes. So normal replication couldn't keep up. And probably right now he is switching the objects, renaming and handling the grants -- our only occasional window before nightly stuff kicks in. So do a full copy from the staging DB. We (or maybe just I, though I'm sure the other person would have preferred to be doing other things) want to avoid having to do that -- we would rather keep up with "normal" replication. And we normally do, just a little more changes now and for the next 6 months or so. And then the feeds will get things up to normal and the volume of changes, at least with regard to updates, will decrease significantly.

Regards,

Larry G. Elkins
elkinsl_at_flash.net
214.954.1781

> -----Original Message-----
> From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Khedr,
> Waleed
> Sent: Tuesday, January 14, 2003 8:24 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Parallel Replication of Single Table
>
>
> I remember too being able to achieve parallelism (8.1.7) with CTAS or
> inserts across DB's too but I'm not able to achieve this now. I tried it
> from the source side and the target side without success. It's always
> serial.
>
> Curious how you are able to test this.
>
> Thanks
>
> Waleed
>
> -----Original Message-----
> Sent: Tuesday, January 14, 2003 7:59 PM
> To: Multiple recipients of list ORACLE-L
>
>
> > I am not sure about replication but in the past (on 8.1.5 and 8.1.6
> > versions) this has been my experience with CTAS over a dblink
> or DML over
> > dblink in that it serializes.
> > In order to achieve parallelism, the only workaround we had was (though
> > not pretty :-) ) to use the ROWID hint on the CTAS and build a set of
> > partition tables at the target and then merge them into a single table.
>
> We are able to achieve parallelism (8.1.7) with CTAS or inserts
> across DB's
> as long as we initiate the SQL from the *target* side. In this
> case you will
> see the parallelism on both the source and target side. Use it
> fairly often
> to move massive amounts of data.
>
> Larry G. Elkins
> elkinsl_at_flash.net
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Larry Elkins
> INET: elkinsl_at_flash.net
>
> 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.net
> --
> Author: Khedr, Waleed
> INET: Waleed.Khedr_at_FMR.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.net
-- 
Author: Larry Elkins
  INET: elkinsl_at_flash.net

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).