My Oracle Support Banner

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

Last updated on MAY 11, 2022

Applies to:

Oracle GoldenGate Big Data and Application Adapters - Version 21.3.0.0.0 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


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