Oracle-L: Re: SharePlex info

From: raju pa <raju_pa_24_at_yahoo.com>
Date: Thu, 21 Aug 2003 12:59:27 -0800
Message-ID: <F001.005CC04A.20030821125927@fatcity.com>

You would need less network bandwidth with shareplex than you would for transporting archive logs. about 1/3 rd of what you would need for physical stdby.
CPU burden would be 'little' I guess.
Shareplex replication allows you to have the table available for read on the target. (even update). If you need this or if it is a great advantage then you can consider shareplex. Else physical stdby would be better.

You have to basically consider the huge cost of shareplex and maintenance it needs. CPU usage of source would be a lesser consideration i think.

somedays back there was a thread on this started by one Nelson ( I think) so you can maybe look at the archives and that should help you make a decision.

"Gorbounov,Vadim" <vadim.gorbounov_at_liberate.com> wrote: @font-face { font-family: Tahoma;}@font-face { font-family: Trebuchet MS;}@page Section1 {size: 8.5in 11.0in; margin: 1.0in 1.25in 1.0in 1.25in; }P.MsoNormal { FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"}LI.MsoNormal { FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"}DIV.MsoNormal { FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"}A:link { COLOR: blue; TEXT-DECORATION: underline}SPAN.MsoHyperlink { COLOR: blue; TEXT-DECORATION: underline}A:visited { COLOR: purple; TEXT-DECORATION: underline}SPAN.MsoHyperlinkFollowed { COLOR: purple; TEXT-DECORATION: underline}SPAN.EmailStyle17 { COLOR: navy; FONT-FAMILY: Arial}DIV.Section1 { page: Section1}Hi All,

I'm trying to find some technical details about SharePlex, that is:

How much network bandwidth I'd expect to replicate from database, generating 1-5 MB/sec redo. Does SharePlex send SQL text over the network or data in some internal (hopefully compressed) format
How much CPU on the source DB server side would it cost - just a ball park - very little- little - or a lot
Of two options, using 9.2 physical async standby db and clone whole database vs replicate 50% (enough from business requirements) of tables using SharePlex, which one sounds preferrable keeping in mind minimizing CPU burden on the source database.

Any opinion or pointer to any benchmark is highly appreciated.

Thanks a lot
Vadim

Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: raju pa
  INET: raju_pa_24_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).

Received on Thu Aug 21 2003 - 15:59:27 CDT