Re: Data Replication performance

"Tobias Johansson" <toby_one_canoby_at_hotmail.com> schrieb im Newsbeitrag news:a64d0b53.0410010418.1efa92a3_at_posting.google.com...
> I'm seearching for information regarding database replication
> performance. We need to compare the performance of replication for SQL
> Server and Oracle and it is urgent! Anyone who can describe the
> performance bottlenecks for each database when performing replication,
> or can point me to a white paper or webpage.
For oracle you haveseveral modi, from maximum security (slowest) to maximum performance (guess).
Maximum performance means, the log doesn't have to be transferred for the master to go on, so it can lag a bit. On the other hand, the replication is pretty fast in the normal case because the mechanism is just the log transfer. You don't really need the standby to execute the log in order to have the master go on. It's enough to have the log transferred. This will increase performance but will slow down switchover because the standby will have to process lots of logs before it can get online. Thre are quite a few screws to fiddle around with in oracle and if you want to tompare to M$ sql server you need to tell us how exactly it works there so that we can then tell you about the corresponding settings in oracle and their performance.

Lots of
Greetings!
Volker Received on Fri Oct 01 2004 - 09:57:50 CDT