• Version
• Download 24
• File Size 487.37 KB
• Download

Performance Analysis of Oracle APEX Applications in Multi-Tenant Cloud Environments

Ashraf Syed

Corresponding author: Ashraf Syed (e-mail: maverick.ashraf@gmail.com).

ABSTRACT The rapid adoption of multi-tenant cloud environments has transformed how enterprises deploy database-driven applications, offering cost efficiency and streamlined management. Oracle Application Express (APEX), a leading low-code platform integrated with Oracle Database, is increasingly utilized in such setups to develop scalable web applications. This paper investigates the performance of APEX applications within multi-tenant cloud environments, leveraging Oracle Database Multitenant architecture. We configured a container database (CDB) hosting multiple pluggable databases (PDBs), each running identical APEX applications, and employed Oracle Resource Manager to allocate CPU and memory resources dynamically. Performance was assessed under varying user loads (10 to 100 concurrent users) using metrics such as page load times, throughput, and resource utilization, collected via Oracle Cloud Infrastructure (OCI) monitoring tools and APEX Activity Logs. Results demonstrate that effective resource management ensures consistent performance across tenants, with optimized PDBs maintaining sub-second response times even at peak loads. However, resource contention can degrade performance without proper tuning, such as SQL optimization and region caching. This study provides actionable insights for deploying APEX in multi-tenant clouds, highlighting the importance of monitoring and resource allocation to maximize low-code benefits. Future work could explore scalability limits and advanced tuning strategies.

Keywords: Oracle APEX, Multi-Tenant Architecture, Cloud Performance, Resource Management, Low-Code Platforms, Oracle Database, Scalability, Performance Tuning, Oracle Cloud Infrastructure (OCI), Tenant Isolation.