My Oracle Support Banner

Application Express (APEX) Reports Performance is Slow When Data is Fetched From a Remote Database (Doc ID 727834.1)

Last updated on APRIL 02, 2019

Applies to:

Oracle Application Express (APEX) - Version 1.6 and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

When running an APEX Report where the data is selected from a remote database via a database link, the performance of the report is extremely slow. If the data is local then there is no problem.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.