Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Problem when using dblink from APEX

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.

Comments
Post Details
Added on Mar 31 2023
3 comments
838 views