GoldenGate replicated very slow on delete operations
Hi,
We're using Streams before, but now we're planning to move Streams to GoldenGate. Now we are doing a testing to compare their replication performance, we found that delete operations are replicated very slow in GoldenGate, while inserts and updates are OK.
The table S05_SIM_RTDB under test has no primary key defined, so we defined a disabled primary rely constraint on the unique indexed column SIM_KEY.
SQL> select index_name from user_indexes where table_name = 'S05_SIM_RTDB' and UNIQUENESS = 'UNIQUE';
INDEX_NAME
--------------------------------------------------------------------------------
UK_S05_SIM_RTDB01
SQL> select COLUMN_NAME from user_ind_columns where INDEX_NAME='UK_S05_SIM_RTDB01';