Oracle Database Free Edition (also known as Oracle Database 23ai Free) is Oracle's no-cost, perpetual license version of Oracle Database — positioned for developers, learning, and low-scale production use. Oracle designed Free Edition to lower the barrier to Oracle Database adoption and create a pathway to paid Oracle Database licenses as deployments scale. What Oracle's marketing does not emphasise is that Free Edition carries hard technical limits, specific license restrictions that prohibit certain commercial uses, and that organizations frequently exceed the free tier boundaries without realizing they have crossed into chargeable Oracle license territory. This guide explains exactly what the Free Edition permits, where the boundaries lie, and how to upgrade without creating back-license exposure.
Oracle Database Free Edition (released in 2023 as part of the Oracle Database 23ai launch) is the successor to Oracle Database Express Edition (XE), which Oracle discontinued. Both are free, resource-limited versions of Oracle Database, but Free Edition is based on Oracle Database 23ai — Oracle's most recent major release — rather than the older Oracle Database 21c codebase that was Oracle XE's final version.
The key differences between Oracle Database XE and Oracle Database Free Edition are incremental rather than architectural: Free Edition increases the RAM limit from 2GB (XE) to 12GB, increases the CPU thread limit from 2 (XE) to 2 CPU threads (same), and increases user data storage from 12GB (XE) to 20GB. The most significant difference is that Free Edition runs on Oracle Database 23ai and includes modern features such as JSON Relational Duality, SQL Domains, True Cache, and AI Vector Search — features not present in XE.
| Feature | Oracle DB XE (21c) | Oracle DB Free (23ai) |
|---|---|---|
| Database version | 21c | 23ai |
| CPU threads | 2 threads | 2 CPU threads |
| RAM limit | 2GB | 12GB |
| User data storage | 12GB | 20GB |
| Multitenant (CDB/PDB) | 1 PDB | 3 PDBs |
| AI Vector Search | No | Yes |
| JSON Relational Duality | No | Yes |
| Cost | Free, perpetual | Free, perpetual |
| Oracle Annual Support | Not included / not required | Not included / not required |
Oracle Database Free Edition is available for download from Oracle's website without an Oracle account — it does not require acceptance of a commercial license agreement beyond the Oracle Free Use Terms and Conditions, which govern the resource limits and use restrictions.
Oracle Database Free Edition enforces its resource limits in software — the database engine itself restricts CPU, RAM, and storage usage to the permitted maximums. Unlike Oracle's commercial edition licensing, which relies on compliance declarations and audit enforcement, Free Edition's limits are enforced at the database level and cannot be bypassed through configuration changes.
The limits are enforced, not just contractual: Free Edition's CPU, RAM, and storage limits are technically enforced by the database engine. If your application approaches these limits and requires more capacity, you will need to upgrade to a licenced edition — at which point Oracle will expect commercial license fees from the point of need. Planning the upgrade timing is a commercial decision that benefits from independent advice.
Oracle Database Free Edition is licenced under Oracle's Free Use Terms and Conditions. The key commercial boundaries in these terms are more permissive than most Oracle licensing contexts — but the exceptions are commercially significant.
The production use permission is the most commercially significant Free Edition feature. Oracle explicitly permits production deployment within the resource limits. An organization running a low-volume production application on Oracle Database Free Edition — within the 2 CPU threads, 12GB RAM, and 20GB user data constraints — has no Oracle license obligation. This is a genuine commercial benefit, particularly for smaller organizations and specific low-scale production workloads.
Oracle Database Free Edition includes substantially all Oracle Database 23ai features that do not require separate optional license purchases. This is considerably more feature-rich than Oracle Database Express Edition was, and makes Free Edition genuinely capable for a broad range of workloads within its resource limits.
Notably included without additional license: SQL and PL/SQL full capabilities, Oracle APEX (Application Express) for web application development, Oracle REST Data Services (ORDS) for REST API access to the database, JSON Relational Duality Views, AI Vector Search (for embedding-based similarity search), SQL Domains (data type constraints), True Cache (read-only in-memory cache), and the Oracle Database Vault configuration framework (though activation may be limited in Free Edition).
Oracle options that are not included in Free Edition and would require a commercial license to use: Diagnostics Pack and Tuning Pack (AWR, ASH, ADDM), Partitioning option, Advanced Security (TDE, Data Masking), Real Application Clusters (RAC), In-Memory option, and GoldenGate integration. These are the same options that require separate licenses in Oracle Database EE — the absence in Free Edition is consistent with Oracle's overall options licensing approach.
Options activation risk in Free Edition: Oracle Database 23ai's default installation may show certain options as present in DBA_REGISTRY or v$option views even in Free Edition. Some of these views reflect code presence, not license entitlement. Using AWR (Automatic Workload Repository) or ADDM in a Free Edition installation — even inadvertently — could be construed as Diagnostics Pack usage if the database is later migrated to a commercial edition. Proactive clean-up of options usage before migration is advisable.
Oracle's LMS audit team does not typically audit Oracle Database Free Edition deployments — they have no commercial claim against a compliant Free Edition installation. The commercial exposure arises in three specific scenarios that our compliance review team encounters regularly.
When a Free Edition deployment exceeds the resource limits — typically because user data approaches 20GB or the application requires more than 12GB RAM — the natural response is to upgrade to Oracle Database SE2 or EE. Oracle's position is that the commercial license obligation begins on the date the upgrade occurs or was required — not earlier. However, if Oracle's LMS scripts discover that a commercial edition has been installed on hardware that was previously running Free Edition, Oracle will examine whether the resource limits were the reason for the upgrade and whether any commercial Oracle software (such as licenced Database options) was used during the transition period.
Oracle's Oracle Technology Network (OTN) Developer License permits use of commercial Oracle Database software for development and testing without charge. Some organizations use Oracle Database Free Edition for development instead of the OTN Developer License path — this is generally fine, but creates a complication if the production system uses options (such as Partitioning) that are not available in Free Edition. Testing on Free Edition without the options available in production creates functional gaps and is not a recommended development practice for option-heavy production systems.
ISVs and SaaS providers that build products using Oracle Database Free Edition as the database tier must review Oracle's Free Use Terms carefully. Providing Oracle Database capability to customers as part of a commercial service — even under Free Edition — may require Oracle's commercial ISV program agreement. This is a recurring issue for software vendors who adopt Free Edition for a product's embedded database component without seeking legal counsel on Oracle's ISV terms.
For organizations uncertain about their Free Edition compliance position or planning an upgrade to SE2 or EE, our license optimization team provides an independent assessment of the optimal upgrade path and license structure.
| Feature / Limit | Free Edition (23ai) | Standard Edition 2 | Enterprise Edition |
|---|---|---|---|
| Cost | Free, perpetual | ~$17,500/Processor | ~$47,500/Processor |
| CPU threads | 2 threads | Up to 16 CPU threads per instance | Unlimited |
| RAM | 12GB | Unlimited | Unlimited |
| User data | 20GB | Unlimited | Unlimited |
| RAC | No | No (OCI/on-premise) | Yes (with RAC option) |
| Partitioning | No | No (separate license) | Yes (with option) |
| Diagnostics/Tuning Pack | No | No (separate license) | Yes (with option) |
| Advanced Security (TDE) | No | Yes (included in SE2) | Yes (with option) |
| Annual support | Not required | 22% of license | 22% of license |
| Production use | Yes (within limits) | Yes | Yes |
The SE2 vs EE choice for organizations upgrading from Free Edition depends primarily on workload characteristics. SE2's 16-thread CPU cap (hard limit, technically enforced since SE2 2020.1) and the absence of RAC and most EE-only options make it suitable for mid-tier applications that do not require high concurrency or Enterprise Edition features. The license cost differential — roughly one-third of EE per Processor — makes SE2 the economically correct choice for workloads that fit within its capabilities.
Our SE2 vs Enterprise Edition comparison guide covers the decision framework in detail for organizations choosing between editions.
Upgrading from Oracle Database Free Edition to SE2 or Enterprise Edition requires both a technical database upgrade process and a commercial license purchase. The technical migration is straightforward — Oracle Database Free Edition's on-disk format is compatible with SE2 and EE on the same major version (23ai). The commercial and compliance considerations are more complex.
The standard upgrade path from Oracle Database 23ai Free to Oracle Database 23ai SE2 or EE is: install the target edition (SE2 or EE) on the same server or a new server, use Oracle's DBUA (Database Upgrade Assistant) or Data Pump export/import to migrate the database, and verify the post-migration environment against your SE2 or EE license entitlement.
When purchasing Oracle Database SE2 or EE to replace a Free Edition deployment, Oracle typically prices the commercial license based on the server's full processor count — applying the Core Factor Table to calculate the Processor license requirement. This is the correct license basis for the production environment, but enterprises frequently underestimate the required license count when planning the budget for Free Edition upgrades.
Oracle's sales process for Free Edition upgrades is also a commercial risk: Oracle uses the upgrade conversation to propose broader Oracle master agreement structures, ULA options, or cloud-first OCI commitments that may not align with the organization's actual requirements. Our contract negotiation team provides independent support for these conversations — ensuring enterprises purchase exactly what they need at a defensible price, rather than accepting Oracle's initial proposal.
Our independent advisory benchmarks Oracle's SE2 and EE pricing against market norms, identifies the minimum license footprint for your workload, and prepares the commercial position before you engage Oracle's sales team. Clients typically achieve 30–50% savings versus Oracle's initial proposal on new license purchases.
Practical Oracle licensing analysis — audit trends, negotiation benchmarks, and database licensing updates for enterprise buyers. No Oracle spin.
Unsubscribe anytime. No Oracle affiliation.
Our contract negotiation team and license optimization service prepare enterprises for Oracle Database license purchases — benchmarking Oracle's pricing, identifying the minimum compliant license footprint, and challenging Oracle's initial commercial proposals. Former Oracle insiders — not affiliated with Oracle.