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

Last updated on OCTOBER 27, 2016

Applies to:

Oracle Application Express (formerly HTML DB) - Version 1.6 and later
Information in this document applies to any platform.
***Checked for relevance on 18-Jun-2012***
***Checked for relevance on 16-Dec-2013***

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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms