Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: SharePlex info

RE: SharePlex info

From: Gorbounov,Vadim <>
Date: Fri, 22 Aug 2003 05:24:31 -0800
Message-ID: <>


My question was inspired by belief that SharePlex does log mining on the source DB and hence do not send unnecessary data over the network. Apparently, this is not the case. I didn't want to compare SharePlex to logical standby cause I know that logical standby definitely needs all logs transported to the target site where is does log mining. We considering remote disaster recovery site where we want to have working data and we don't care much about "log" tables.  

Thank you for valuable info.

-----Original Message-----
Sent: Thursday, August 21, 2003 5:44 PM
To: Multiple recipients of list ORACLE-L

Your bandwidth requirements will be the rate of changes to the actual data. The traffic consists of the actual data and control information needed to reassemble the transaction on the target. The source database's other redo payload (i.e., index operations, rollback segment maintenance, etc.) is not used by Shareplex.  

In our environment of dual Sun 6800's, 10 CPU's each, we observe less that 1% CPU consumption on the source and target sides combined. It varies according to the DML load on the source but not by much. We've never had a problem with it consuming a noticeable amount.  

I have a question on the comparison between a physical standby and Shareplex replication. Isn't 9i's logical standby feature better suited for the comparison to Shareplex? I'm assuming that you are considering offloading some processing to another host since you are looking to replicate about 50% of the tables in the source database.  

Tony Aponte    

-----Original Message-----
Sent: Thursday, August 21, 2003 1:49 PM
To: Multiple recipients of list ORACLE-L

Hi All,  

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

Any opinion or pointer to any benchmark is highly appreciated.  

Thanks a lot

Please see the official ORACLE-L FAQ:
Author: Gorbounov,Vadim

Fat City Network Services    -- 858-538-5051
San Diego, California        -- Mailing list and web hosting services
To REMOVE yourself from this mailing list, send an E-Mail message
to: (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 Fri Aug 22 2003 - 08:24:31 CDT

Original text of this message