Goldengate 23.4.0.24.06 to BigQuery data replication very slow
Hello Experts,
We have OGG Microservices installation and trying to replicate data from Oracle to Bigquery, but the replicat process is pathetically slow, how can we tune it?.
here are our environment details:
Oracle GoldenGate Services 23.4.0.24.06 for Distributed Applications and AnalyticsProperties file for Replicat#Google BigQuery Handler Template
gg.handlerlist=bigquery
gg.handler.bigquery.type=bigquery
#TODO: Set the Google project id.
gg.handler.bigquery.projectId=****************
#TODO: Set the path to the Google credentials file.
gg.handler.bigquery.credentialsFile=****************
gg.handler.bigquery.auditLogMode=false
gg.handler.bigquery.enableAlter=true
gg.handler.bigquery.metaColumnsTemplate=${optype},${position}
gg.handler.bigquery.StreamBatchSize=5000000
0