Re: Any one used Symetric replication?

I am preparing to put a multi-master database in production with 3 facilities in the replicating to a central database. A couple of things to note, your system tablespace will need to be increased to hold the replication code. Transactions are committed in both databases at the same size. I other words if you do a really large transaction using a large rollback segment the receiving system will need just as big a rollback segment to complete the transaction. Only I know of no way to ensure that the replication user will have the biggest rollback segment ! Also deletes and updates of data send the entire before and after image of every record changed, causing considerably more transmission overhead than might otherwise be needed, one way to avoid this is to use replicated procedures to handle database udpates. Good luck with the project, mine has been interesting all along.

Bob
In article <32185B46.5BDB_at_ontonet.be>, mike.hogan_at_ontonet.be says...
>
>We are about about to embark on a major project redeveloping our main
>system which is installed in over 25 countries. We are migrating from a
>Clipper/dBase environment to Delphi2/Oracle. The current system makes
>extensive use of DB replication which has been developed in house (Crude
>but effective).
>
>We are planning to use the Symetric Replication facility provided in
>version 7.2 Server and Personal Oracle to save us having to redevelop
>this functionality a second time.
>
>Please can anyone tell me of their experiences with this package in a
>real life project. Any tales of tears or laughter would be appreciated.
>
>Thanks
>
>Mike Hogan
Received on Thu Aug 22 1996 - 00:00:00 CEST