Infrastructure: I have deployed oracle database at 5 remote locations and a web application that is deployed on 4 sites which accesses those oracle database, each working independently. However database on each site are synchronized with other database sites through Oracle Golden Gate.
Problem: At some point in time database active session on 1 of the site keep on increasing making the web application irresponsive (all database operations are halted) unless I stop golden gate replication on that particular site.
I tried to assess SQL queries that are taking too long in database sessions, but those seems normal queries which work fine when sessions are low.
Am I missing any golden gate configuration or there is any other area to probe?