Hello everyone, we are in the process of migrating our systems to AWS, where we have an RDS database service in Canada, with:
APEX: 22.1.6 patch 6
DATABASE: Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0
ORDS : 21.1.3.r1531102
Apache Tomcat: 8.5.83
The system uses a DBLINK to a database located in Argentina, when I consume the dblink from AWS to the Argentina database using SQL DEVELOPERS everything works fine, but when I want to consume the dblink from the application or query from the SQL COMMAND of the SQL WORKSHOP gets EVERYTHING slow, even parts of the application that have nothing to do with DBLINK, that makes us think that ords/tomcat is not managing the session well.
Attached a screenshot of a page loading before and after using dblink. Can you think of what it could be?
A cordial greeting from Argentina.