Home » Server Options » Replication » How can I tune my DB for using whole canal width?
How can I tune my DB for using whole canal width? [message #75181] Wed, 22 May 2002 20:46 Go to next message
Victork
Messages: 1
Registered: May 2002
Junior Member
I have 2 DB - master and snapshot
when I have refresh operation - the speed of tranfer is 1K/s - it's no good :))

But when I use sqlplus and connect from one site to other and set arraysize 5000 in sqlplus I have spees of trans - 8K/s - it's like good.

The questions is:
How tune the DB from say to use alll of canal with ?
How set arraysize for all DB as default?

Thanks in advise
Re: How can I tune my - dedicated replication link? [message #75185 is a reply to message #75181] Sat, 25 May 2002 10:54 Go to previous message
David Simpson
Messages: 29
Registered: May 2002
Junior Member
You might consider dedicating a communications link between the replicated database servers. The replication scripts created by my Repgen application automatically make use of dedicated network cards for replication.

You might want to look at the sample scripts on my web site:
http://www.dotcomsolutionsinc.net/products/repgen/repgen_files.html

Or you may download a demo version and look at the sample scripts on your own computer:
http://www.dotcomsolutionsinc.net/downloads/demo_software/index.html

One of the critical aspects of Advanced Replication which is automatically handled by the scripts created by Repgen 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.html

David Simpson
www.dotcomsolutionsinc.net

Previous Topic: Linking databases
Next Topic: Re: Snapshot auto refresh not working, what are all the parameters to be set
Goto Forum:
  


Current Time: Thu Mar 28 10:15:54 CDT 2024