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 <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
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@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: <[EMAIL PROTECTED]>
X-Comment: Oracle RDBMS Community Forum
X-Sender: mantfield <[EMAIL PROTECTED]>
Sender: [EMAIL PROTECTED]
Errors-To: [EMAIL PROTECTED]
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: [EMAIL PROTECTED]
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:[EMAIL PROTECTED]]
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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
