Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Replicat slow with Oracle to Mongo with golden gate for big data

Arvind ThangamaniOct 16 2024 — edited Oct 17 2024

Have 72 trail files of 2 GB each.

With a single replicat am able to only get to 10,000 document inserts per second and a transfer speed of 3 MB/s.

There is no crunch of resource on gg server or on my mongo server.

I tried running 10 parallel replicats which gets me about 80,000 document inserts per second and a transfer speed of 18 MB/s.

This is not sufficient. When i try upload a normal file from source to destination am able to get 130 MB/s. Network is not an issue.

replicat does not even get to 25% of total JVM memory allocated.

What are some parameters i can play with or where could the bottleneck be. Kindly assist

Oralce version 19c

This is my replicat configuration:

REPLICAT MY_REPLICAT
TARGETDB LIBFILE libggjava.so SET property=/data/mongo.props
REPORTCOUNT EVERY 1 MINUTES, RATE
GROUPTRANSOPS 40000
MAP SCHEMA.TABLENAME,TARGET "schema"."collection_08102024"

This my mongo.props:

gg.handler.mongodb.WriteConcern={"w":"1", "wtimeout": "0"}

gg.handler.mongodb.BulkWrite=true

gg.handler.mongodb.upsert=false

jvm.bootoptions=-Xmx8048m -Xms8048m

javawriter.bootoptions=-Xms4048m -Xms4048m

Target is a self-managed 4 shard mongo cluster

Comments

InoL Apr 29 2024

How doc gen treats nulls values?

You have to be more specific. Are your referring to the pre-built Document Generator function?

If so:

When my query return null in some columns

What is the JSON that is generated?

You should always include the element in the JSON, with an empty value. Don't leave it out.

Francois Robert-Oracle Jan 8 2025 — edited on Jan 8 2025

Since September 2024, when a tag has no corresponding value in the JSON data or the value is null, the tag is replaced by an empty string.

See the September Release Notes

1 - 2

Post Details