Oracle GoldenGate Bigdata SLOW LOB Replication To Snowflake (Doc ID 2865162.1)

Last updated on MAY 11, 2022

Applies to:

Symptoms

We are migrating our database to Oracle to snowflake , we are getting an issue where BLOB from Oracle to Snowflake replication via golden gate very slow.
This is the case with initial load for table which hold BLOB.

INFO  2022-04-01 12:46:42.000652 [main] - Operation aggregator is flushing merged operations because the current operation contains at least one out of line LOB column value that exceeds [16000] bytes.
INFO  2022-04-01 12:46:43.000192 [main] - Operation aggregator is flushing merged operations because the current operation contains at least one out of line LOB column value that exceeds [16000] bytes.
INFO  2022-04-01 12:46:45.000100 [main] - Operation aggregator is flushing merged operations because the current operation contains at least one out of line LOB column value that exceeds [16000] bytes.
INFO  2022-04-01 12:46:46.000012 [main] - Operation aggregator is flushing merged operations because the current operation contains at least one out of line LOB column value that exceeds [16000] bytes.
INFO  2022-04-01 12:46:46.000273 [main] - Operation aggregator is flushing merged operations because the current operation contains at least one out of line LOB column value that exceeds [16000] bytes.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.