GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

GoldenGate replicated very slow on delete operations

edited May 7, 2019 10:10PM in GoldenGate, Streams and Distributed Database (MOSC) 6 commentsAnswered ✓

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';

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center