Best practice for high volume data transfer via connectivity agent for database

Summary:

Best practice for high volume data transfer via connectivity agent for database

Content (please ensure you mask any confidential information):

Would like to know if team members experienced database agent degradation when processing high volume of transactions via connectivity agent.

I received a feedback from a project team based on their experience that the OIC database agent experienced frequent downtime due to high data load and required frequent bounce.

This will be very discouraging as we have a use case where we need to connect to a EBS database across firewall and via agent to send critical transactions which can go to half million in count.