Application Express (APEX) Performance Tuning and Scalability Factors
(Doc ID 1418234.1)
Last updated on FEBRUARY 09, 2023
Applies to:
Oracle Application Express (APEX) - Version 3.2.1 and laterOracle Database - Enterprise Edition - Version 10.1.0.2 and later
Oracle Database Backup Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database 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 |