Re: SharePlex info

2003-08-25 Thread Yechiel Adar
, Tony To: Multiple recipients of list ORACLE-L Sent: Friday, August 22, 2003 10:39 PM Subject: SharePlex info You are correct in the first place. SharePlex works as you describe, it mines the log and sends only the absolute minimum to reassemble the transaction on the target

RE: SharePlex info

2003-08-25 Thread Tim Onions
NT. T¬-Original Message-From: Yechiel Adar [mailto:[EMAIL PROTECTED]Sent: 25 August 2003 09:10To: Multiple recipients of list ORACLE-LSubject: Re: SharePlex info Sorry about the late reply but (if I remember correctly from my research about one year ago) Shareplex does something lik

RE: SharePlex info

2003-08-22 Thread Gorbounov,Vadim
[mailto:[EMAIL PROTECTED]Sent: Thursday, August 21, 2003 5:44 PMTo: Multiple recipients of list ORACLE-LSubject: RE: SharePlex info 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

SharePlex info

2003-08-22 Thread Aponte, Tony
: SharePlex info Tony, 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

Replication options Was: SharePlex info

2003-08-22 Thread tjambu_fatcity
Hi there In the past few weeks, there have been lots of discussion about HA, data replication and using Shareplex, dataguard, Streams, logical physical standby. As most of you have found out each has it own pros and cons. You also need two sets of Database licences and Shareplex licences. Then

SharePlex info

2003-08-21 Thread Gorbounov,Vadim
Title: Message 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. DoesSharePlex send SQL text over the network or data in some internal (hopefully compressed)format -

Re: SharePlex info

2003-08-21 Thread raju pa
1)You would need lessnetwork bandwidth with shareplex than you would for transporting archive logs. about 1/3 rd ofwhat you would need for physical stdby. 2) CPU burden would be 'little' I guess. 3) Shareplex replication allows you to have the table available for read on the target. (even

Re: SharePlex info

2003-08-21 Thread Tanel Poder
. - Original Message - From: Gorbounov,Vadim To: Multiple recipients of list ORACLE-L Sent: Thursday, August 21, 2003 8:49 PM Subject: SharePlex info Hi All, I'm trying to find some technical details about SharePlex, that is: - How much network

RE: SharePlex info

2003-08-21 Thread Gorbounov,Vadim
Thank you, Raju. Very helpful -Original Message-From: raju pa [mailto:[EMAIL PROTECTED]Sent: Thursday, August 21, 2003 4:59 PMTo: Multiple recipients of list ORACLE-LSubject: Re: SharePlex info 1)You would need lessnetwork bandwidth with shareplex than you would

RE: SharePlex info

2003-08-21 Thread Aponte, Tony
to replicate about 50% of the tables in the source database. HTH Tony Aponte -Original Message-From: Gorbounov,Vadim [mailto:[EMAIL PROTECTED]Sent: Thursday, August 21, 2003 1:49 PMTo: Multiple recipients of list ORACLE-LSubject: SharePlex info Hi All, I'm trying

RE: SharePlex info

2003-08-21 Thread Gorbounov,Vadim
: Thursday, August 21, 2003 5:14 PMTo: Multiple recipients of list ORACLE-LSubject: Re: SharePlex info 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

Re: SharePlex info

2003-08-21 Thread Tanel Poder
But you would be wanting to transfer *full* logfiles away from your production servers anyway at least if your data is worth something... Tanel. 1)You would need lessnetwork bandwidth with shareplex than you would for transporting archive logs. about 1/3 rd ofwhat you

Re: SharePlex info

2003-08-21 Thread Tanel Poder
. - Original Message - From: Gorbounov,Vadim To: Multiple recipients of list ORACLE-L Sent: Friday, August 22, 2003 12:54 AM Subject: RE: SharePlex info Tanel, That's nice trick, thanks a lot. In this casewhole redo steam must be passed over the network anyway. 5

RE: SharePlex info

2003-08-21 Thread A Joshi
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-From: Tanel Poder [mailto:[EMAIL PROTECTED]Sent: Thursday, August 21, 2003 5:14 PMTo: Multiple recipients of list ORACLE-LSubject: Re: SharePle

Re: SharePlex info

2003-08-21 Thread Tanel Poder
: Friday, August 22, 2003 2:14 AM Subject: RE: SharePlex info 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" [EMAIL