Hi guys,

I have the following challenge at hand.
Oracle 8.1.6

Situation : I have a central database and 5 other regional database that get a small percentage of data from the central database. We replicate a total of 67 snapshots. Some are fast refresh others cannot be since they have complex queries associated with them.
Replication takes place every 2 hours.

Problem with current setup : We like to make the replication intervals as close to real time as possible. Secondly i seem to have a problem with locks on the mlog$ tables when more than one site tries to replicate the same data at the same time. Thirdly replicating to 5 sites puts a strain on the performance of the central database.

Any thoughts to help me with my challenge

By the way is my thinking right to say that snapshot replication is a pull and advanced replication is a push. ????

Kind Regards
Vishaal