My Oracle Support Banner

Application Express (APEX) Performance Tuning and Scalability Factors (Doc ID 1418234.1)

Last updated on MAY 08, 2020

Applies to:

Oracle Application Express (APEX) - Version 3.2.1 and later
Oracle Database - Enterprise Edition - Version 10.1.0.2 and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.
The concepts here apply to all versions of APEX but this bulletin was built on information specific to APEX 4.0 and above.


Purpose

The purpose of this document is to aid in the understanding and diagnosis of APEX application performance and scalability related issues. Since the APEX application resides in the Oracle Database, it is important to understand what specific areas should be reviewed when there is a performance concern. Users of the APEX application may see poor response, unexplained errors, limited access, no access, etc., while the DB itself may exhibit high CPU utilization or even hang. Real life experience has shown that the majority of APEX performance and scalability related issues are APEX application tuning issues or DB related configuration or tuning issues. Only in rare instances have any bugs been identified with any underlying APEX architectural component.


Note: Please read the "official sizing guide for Oracle Application Express" before continuing with this note.

Scope

The information in the bulletin is intended for both APEX application developers and DBAs.

Details

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
Purpose
Scope
Details
References

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