Re: Symmetric replication - Parameters

Siddhartha,

Here is a tech note which discusses performance issues, batch operations and dealing with many replicated tables:
http://www.dotcomsolutionsinc.net/support/repgen/repgen_tn_replication_desig n.html

When I attended the Advanced Replication class, they told us that generally replication was usable for situations in which there were fewer than 400 transactions per second. Of course this is dependent upon the network connections between the machines, the amount of data in each transaction, how many other tasks are going on with the server and the overall performance of the server. It would be highly recommended to perform a prototype setup between a couple of servers to test as many of these variables as possible.

There is an application which can help you automate writing of the Replication setup/monitoring scripts:
http://www.dotcomsolutionsinc.net/downloads/demo_software/index.html

This app will give you some ideas of basic info you would require, such as Oracle version, grouping of tables and separate network interfaces for improved performance.

One of the critical aspects of Advanced Replication which needs considered is the setup of conflict resolution. An incorrect setup of the conflict resolution parameters will cause data divergence between the replicated systems - which is not desirable.
http://www.dotcomsolutionsinc.net/products/repgen/repgen_features_benefits.h tml

David Simpson
www.dotcomsolutionsinc.net

"Siddhartha Jain" <losttoy2000_at_yahoo.co.uk> wrote in message news:2c39af62.0205312107.3aebfb24_at_posting.google.com...
> Hi,
>
> I need to do symmetric replication for a Oracle database over a WAN
> for disaster recovery. What questions do i need to ask to do
> replication as well as bandwidth sizing for the application?
>
> 1. The Oracle version, OS and the machine specs?
> 2. The number of tables in the database?
> 3. The size of each table?
> 4. The transactions per sec on each table?
> 5. The number of concurrent connections per sec?
> 6. The read/write rate of Oracle to the disk per sec?
>
> Can you add more questions?
>
> Regards,
>
> Siddhartha
Received on Sat Jun 01 2002 - 16:23:49 CEST