Goldengate replicats are hosted on a VM and Oracle Database runs on a 4 nodes RAC cluster. All Goldengate processed transactions are running on a specific DB instance and not getting distributed to other nodes. It makes that node highly utilized throughout the day.
Apply receiver, coordinator & server process is running on node 1 at the moment and all DML transactions are also getting queued in Node 1 which is causing Capture/Apply processes in Concurrency and Queuing Wait.
I would like to ensure that GG transaction loads are distributed across across all nodes of RAC database cluster, please help.