How to speed up activation? (28595)

Activation is very slow, how to speed up?

If you are on oracle 9i and above and shareplex 5.x, you can turn on supplemental logging to speed up activation.

1. To turn on supplemental logging:

alter database add supplemental log data;

select supplemental_log_data_min from v$database;
It should show 'YES'.

2. Do a few log switches,
alter system switch logfile;

3. start Shareplex and activate config.

NOTE: If you previously are replicating without supplemental logging turned on, then you need to shutdown shareplex and run ora_cleansp on both source and target before the steps above. If you run ora_cleansp, you will need downtime to activate config but it should be much faster than without supplemental logging enabled.