Oracle-L: RE: SharePlex info

From: A Joshi <ajoshi977_at_yahoo.com>
Date: Thu, 21 Aug 2003 15:14:27 -0800
Message-ID: <F001.005CC080.20030821151427@fatcity.com>

Yes. A nice neat trick indeed. Has anyone tried this?

About your redo generation : 5MB/sec -> 18000 MB/hour == 18GB

IT is indeed huge. IS this peak or average? Good luck.

"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}Tanel, That's nice trick, thanks a lot.
In this case whole redo steam must be passed over the network anyway. 5 MB/sec over WAN. So we'are doing research if we could same some bandwidth.

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

Hi!

Btw, you can physically replicate 50% of your tables with regular standby mechanisms as well. You just take the files belonging to non-needed tablespaces offline and standby recovers only the required part. You just have to arrange your tables to right tablespaces and spend your money elsewhere.

Physical standby and shareplex can operate on archivelogs, thus they can do their jobs without any additional burden to source database CPU, since you generate and archive your logs anyway. You can do archivelog's processing on target or some staging server.

Tanel.

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

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!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: A Joshi
  INET: ajoshi977_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 - 18:14:27 CDT