Site icon IT Tutorial

Goldengate Performance

You should set STREAM_POOL_SIZE  2gb
Disk quality and network bandwith should be high.
You should add heartbeat source and target to analyezed lag.
You should add batchsql , groupstransops 180000 and insertappend at replicat parameter file.
You should do uncompress target table.
You upgrade replicat integrated .
You should add parallel parameter to parameter file for integrated replicat .
You should do replicat parallel with range operations
You should use goldengate_healt_check_report.sql.

Exit mobile version