Excessive redo generation on Master site in a very frequent master/snapshot replication

Hi all,
I have the following problem:
in a Master snapshot replication environment, which starts each 5 secs, regardless the number of DML (which is quite small), a huge quantity of redo logs are produced during a day.

Even if the frequency of replication is very high, only few hundred of rows are replicated per hour, nonetheless, at the master site the redolog entries produced are really a lot of megas.

Mining the logs, I see that each time the snapshot job starts, even though there are no rows to be propagated, an update on the MLOG$ table occurs, which, of course, produces the related entries in the current online redolog.

Unfortunately, since the changes occurs randomly and must be propagated immediately, I need to take the snapshot frequence so high.

As you know, is there a way to avoid this excessive generation of logs?

About the environment:

• Windows 2000 Server
• Oracle EE rel.8.1.7.4

Thanks in advance for any suggestion.

lottini Received on Mon Aug 29 2005 - 05:59:30 CDT