APEX in the Cloud, Zero DBA Required
Oracle Autonomous Database (ADB) is a fully managed Oracle database in OCI that handles patching, tuning, backups, and scaling automatically. It comes with APEX pre-installed and pre-configured, making it the fastest path to a production APEX environment. For developers, ADB eliminates database administration overhead and lets you focus entirely on application development.
Choosing Your Workload Type
ADB comes in two workload types. Autonomous Transaction Processing (ATP) is optimized for OLTP workloads like APEX applications with high-frequency reads and writes. Autonomous Data Warehouse (ADW) is optimized for analytics, reporting, and data warehousing. For APEX applications, ATP is usually the right choice unless your application is primarily a reporting dashboard over large data sets.
Provisioning and Accessing APEX
Create an Autonomous Database instance in the OCI Console. Choose your OCPU count (start with 1 for development), storage (start with 1 TB), and whether to enable auto-scaling. Once provisioned, access APEX through the Service Console link. APEX is immediately available with no additional installation or configuration.
The APEX URL follows this pattern: https://xxxxxxxx.adb.us-ashburn-1.oraclecloudapps.com/ords/apex. Create a workspace, schema, and start building. The ADMIN user can create additional workspaces and manage APEX instances.
Key Differences From On-Premise
ADB restricts certain operations for security and automation. You cannot access the OS or filesystem directly. Some DBA views are restricted. UTL_FILE, UTL_TCP, and UTL_HTTP are replaced by DBMS_CLOUD for external access. Network access requires configuring Access Control Lists through DBMS_NETWORK_ACL_ADMIN or using the OCI Console network settings. ORDS is pre-deployed and managed automatically.
Scaling
ADB supports manual and auto-scaling of compute and storage independently. Enable auto-scaling to automatically increase OCPUs during peak usage and reduce them during quiet periods. You only pay for what you use. Storage auto-extends as needed. For APEX applications with predictable traffic patterns, manual scaling with scheduled changes can be more cost-effective.
Always Free Tier
Oracle offers an Always Free tier that includes one Autonomous Database with 1 OCPU and 20 GB storage, which is perfect for development, testing, and small production APEX applications at zero cost.