Marc,
You didn't mention the Oracle version, but I wouldn't
be surprised if it was O7 as the serial push using the
two-phase commit process doesn't scale well at all.
The completely new architecture (AQ, parallel
propagation, min communication, etc...) in O8 makes
replication quite scalable even at very high
transaction rates.
- Anita
- Marc Perkowitz <mperkowitz_at_twjconsulting.com>
wrote:
> Rao,
> I worked at MCI Teleconferencing for a few years and
> they were using
> SharePlex for a reporting database. Oracle
> replication was not fast enough
> to support their transaction rate and they also
> could not afford the
> overhead on the source database that occurs with
> Oracle replication. After
> a few startup issues, it worked well for them, and
> AFAIK, they are still
> using it.
>
> During their research, they also found that
> Amazon.com was using it for, I
> think, data warehousing -- not their transactional
> system.
>
> Interesting enough, I understand that Oracle has
> built an equivalent feature
> that was planned to be part of 9i. I haven't read
> enough on 9i to see if it
> made it in there or not. Perhaps someone else knows
> about this.
>
> Marc Perkowitz
> Senior Consultant
> TWJ Consulting, LLP
>
> 847-256-8866 x15
> www.twjconsulting.com
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L"
> <ORACLE-L_at_fatcity.com>
> Sent: Tuesday, May 29, 2001 12:16 PM
>
>
> > List,
> >
> > My company is considering Quest - Shareplex.
> >
> > We are considering to use this in our dataware
> house. Basically, this
> will
> > pull all the transactions from OLTP database and
> populate staging area in
> > the dataware house.
> >
> > Could you please give your experiences and the
> pros and cons of this
> > Shareplex product.
> >
> > Thanks,
> >
> > Rao
> > --
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > --
> > Author: Rao, Maheswara
> > INET: Maheswara.Rao_at_Sungardp3.com
> >
> > Fat City Network Services -- (858) 538-5051
> FAX: (858) 538-5051
> > San Diego, California -- Public Internet
> access / Mailing Lists
> >
>
> > 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: Marc Perkowitz
> INET: mperkowitz_at_twjconsulting.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> 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).
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year!
http://personal.mail.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: A. Bardeen
INET: abardeen1_at_yahoo.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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 May 31 2001 - 08:54:19 CDT
