RE: Advanced Rep between 9.2.0 and 8.1.7?

From: Arup Nanda <arupnanda_at_hotmail.com>
Date: Tue, 26 Nov 2002 20:34:25 -0800
Message-ID: <F001.0050D2AA.20021126203425@fatcity.com>

Ferenc,

I have a multimaster setup between 8174 and 920 and works like a charm.

Tables 200
Schemas 5
Total Size 600 Gb
Average Table Size 14 million rows
Transaction per second (from STATSPACK) about 13 Machine HP 6000 servers
OS Windows 2000 Advanced Server

About the setup, there is nothing special about replication between 8ik and 9i, it's pretty much the same as in case of 8i-8i.

HTH Arup Nanda
www.proligence.com

>From: mantfield <mantfield_at_connexus.net.au>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: Advanced Rep between 9.2.0 and 8.1.7?
>Date: Tue, 26 Nov 2002 19:04:04 -0800
>MIME-Version: 1.0
>Received: from mc4-f18.law16.hotmail.com ([65.54.237.153]) by
>mc4-s19.law16.hotmail.com with Microsoft SMTPSVC(5.0.2195.5600); Tue, 26
>Nov 2002 19:32:57 -0800
>Received: from newsfeed.cts.com ([209.68.248.164]) by
>mc4-f18.law16.hotmail.com with Microsoft SMTPSVC(5.0.2195.5600); Tue, 26
>Nov 2002 19:32:55 -0800
>Received: from fatcity.UUCP (uucp_at_localhost)by newsfeed.cts.com
>(8.9.3/8.9.3) with UUCP id TAA56272;Tue, 26 Nov 2002 19:27:42 -0800 (PST)
>Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 0050D197;
>Tue, 26 Nov 2002 19:04:04 -0800
>Message-ID: <F001.0050D197.20021126190404_at_fatcity.com>
>X-Comment: Oracle RDBMS Community Forum
>X-Sender: mantfield <mantfield_at_connexus.net.au>
>Sender: root_at_fatcity.com
>Errors-To: ML-ERRORS_at_fatcity.com
>Organization: Fat City Network Services, San Diego, California
>X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman
>Precedence: bulk
>Return-Path: root_at_fatcity.cts.com
>X-OriginalArrivalTime: 27 Nov 2002 03:32:55.0586 (UTC)
>FILETIME=[AC8DB820:01C295C5]
>
>What is performance like ? how many objects in replication group ?
>
>What I am essentially looking for is performance degradation metrics and
>full specs (# users, machine, OS, size of DB, # rows in largest tables,
>rate of inserts / updates) from source for a one-way replication of about
>500 tables and about 3,000 indexes on these tables. You wouldn't happen to
>have any of those metrics, would you ? Would you ? Pretty please ?
>
>Quests touts that Shareplex is so much better than AR, but how much is that
>? Does it justify the price premium which they are not shy on ? Or should I
>be looking at Shadow Base 3, or Omni-Replicator, or just stick with AR and
>slap in an extra CPU ?
>
>Thanks.
>
>Ferenc Mantfeld
>
>-----Original Message-----
>From: OraCop [SMTP:oracop_at_yahoo.com]
>Sent: Wednesday, November 27, 2002 12:49 PM
>To: Multiple recipients of list ORACLE-L
>Subject: Re: Advanced Rep between 9.2.0 and 8.1.7?
>
>Yes, I am replicating between 8.1.7.3 and 9iR2
>without any issues.
>
> Need help?
>
>OraCop
>
>
>--- Michael Barger <mrbargerusa_at_yahoo.com> wrote:
> > Has anyone heard of or experienced a successful
> > implementation of Advanced Replication between an
> > 8.1.7 database and a 9.2.0 db?
> >
> >
> >
> > __________________________________________________
> > Do you Yahoo!?
> > Yahoo! Web Hosting - Let the expert host your site
> > http://webhosting.yahoo.com
> > --
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > --
> > Author: Michael Barger
> > INET: mrbargerusa_at_yahoo.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).
>
>
>__________________________________________________
>Do you Yahoo!?
>Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
>http://mailplus.yahoo.com
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: OraCop
> INET: oracop_at_yahoo.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: mantfield
> INET: mantfield_at_connexus.net.au
>
>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).

---

Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Arup Nanda
  INET: arupnanda_at_hotmail.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 Tue Nov 26 2002 - 22:34:25 CST