Editorial photograph of an enterprise boardroom interior
Oracle · 23ai Free vs Enterprise · Edition Analysis

Oracle Database 23ai Free vs Enterprise Edition: Where the Feature Line Sits

Oracle 23ai Free is a genuine perpetual no-cost license, but its technical ceilings and use restrictions are built to push production workloads onto paid editions. This analysis names exactly what Free permits, where it forces Enterprise Edition or Standard Edition 2, and how to avoid architecting on features you cannot license affordably at scale.

Contact Us Oracle Hub
500+Enterprise clients
$2B+Under advisory
Industry Recognized
500+ Enterprise Clients
$2B+ Under Advisory
11 Vendor Practices
100% Buyer Side Independent

Oracle 23ai Free is a genuine perpetual no-cost license, but its technical ceilings and use restrictions are built to push production workloads onto paid editions. This analysis names exactly what Free permits, where it forces Enterprise Edition or Standard Edition 2, and how to avoid architecting on features you cannot license affordably at scale.

Oracle Database 23ai Free is positioned as a developer and learning tool, and it is a good one. The commercial risk is not the Free edition itself; it is what happens when a proof of concept quietly becomes a production system. The technical caps are low enough to force a migration, and the moment you migrate, Oracle's price list and its usage logging take over. This page maps the boundary line so you build on the right side of it from day one.

We have negotiated against Oracle's edition and option stack for 25 years. The pattern repeats: a team ships on Free, hits the 12GB user data ceiling, moves to Enterprise Edition on a large server, and discovers a six-figure list bill plus 22 percent annual support. The savings live in decisions you make before that migration, not after. Read this alongside our Enterprise versus Standard Edition comparison and the broader 23ai licensing guide.

What Oracle 23ai Free Actually Permits

Oracle Database 23ai Free is a perpetual, no-cost license and the successor to the discontinued Express Edition (XE). It runs the full 23ai code base, which is what makes it attractive: developers get the real engine, not a stripped fork. The limits are resource ceilings, not feature removals in most cases.

The hard technical caps, per Oracle's documentation, are 12GB of user data on disk, 2GB of RAM, and 2 CPU cores or threads for foreground processes. The 2GB RAM cap is absolute: it does not matter how much memory the host has, Free will not use more. There is a one-install-per-logical-environment restriction, meaning one Free installation per VM, container, or physical host. The pluggable database limit was cut from 252 to 16 in the 23ai release.

Resource 23ai Free limit Practical impact
User data on disk12 GBSYSAUX counts against it (one practitioner reported SYSAUX alone at 3 GB), so usable app data is materially less than 12 GB
RAM2 GB (hard ceiling)No amount of host memory helps; SGA and PGA are bounded
CPU2 cores/threadsAdequate for dev; a practitioner still pushed ~500 transactions/sec within these limits
Pluggable databases16 (was 252)Fine for consolidation testing, tight for multi-tenant SaaS design
Installations1 per host/VM/containerBlocks running multiple Free instances on one node

The throughput point matters: within its caps, Free is not slow. One published test sustained close to 500 transactions per second. That is exactly why teams overrun the license: the engine performs well enough that the storage ceiling, not performance, is what eventually breaks the deployment. Plan for the 12GB wall as a data-growth event, because it will arrive without warning.

The Free edition does not fail on speed. It fails on the 12GB data ceiling, and SYSAUX is eating into that budget before your application writes a single row.

The Production-Use Question: What Free Does and Does Not Cover

This is where buyers get burned. Oracle markets Free as suitable for developers, learning, and low-scale production use, but the terms restrict commercial use in production beyond development, testing, and educational purposes. Independent licensing analysis is consistent that revenue-generating production workloads require a licensed edition (Enterprise Edition or Standard Edition 2). Treat any language about low-scale production as narrow, and read the actual license terms before you deploy anything that touches customers or revenue.

Free also lacks the high-availability features a real production system needs. It is single-instance only: no Real Application Clusters (RAC), no clustering, and limited disaster recovery. Backup and recovery are basic. If your uptime requirement is anything above best-effort, Free is architecturally disqualified regardless of the license text. That single-instance constraint is often the real forcing function, ahead of the data cap.

Our buyer-side position: use Free strictly for development, prototyping, training, and internal non-revenue tooling that fits inside 12GB. The moment a workload is customer-facing, revenue-linked, or needs HA, budget for a paid edition. Do not let a Free proof of concept set architectural expectations that a $47,500-per-processor edition will have to fund. Before any migration, run our pre-migration license review.

The Accidental Option Usage Trap

This is the most expensive and least understood risk on Free, and it only detonates after you migrate. Oracle's 23ai default installation may show certain options as present in DBA_REGISTRY or v$option views even in Free. Those views reflect code presence, not license entitlement. The danger is that using features such as AWR (Automatic Workload Repository) or ADDM inside a Free installation, even inadvertently, can be construed as Diagnostics Pack usage if that database is later migrated to a commercial edition.

Oracle logs all of this. The DBA_FEATURE_USAGE_STATISTICS view records any use of Enterprise Edition options or management packs. In an audit, discovered usage forces you to license that feature per processor, retroactively. So a developer clicking through Enterprise Manager performance screens on Free can plant an evidentiary seed that costs Diagnostics Pack and Tuning Pack money the day you move to Enterprise Edition. Learn to read this data yourself using our guide to Oracle LMS script output.

  • Disable AWR/ADDM sampling and management-pack access controls in any Free installation you might later migrate.
  • Never point Enterprise Manager packs at a Free database intended for production promotion.
  • Snapshot DBA_FEATURE_USAGE_STATISTICS before and after a migration so you can distinguish pre-existing artifacts from post-migration use.
  • Note that Free omits Advanced Compression, Storage Snapshot Optimization, Optimization for Flashback Time Travel History Tables, and Automatic Data Optimization entirely, so those are not accidental-usage risks, they simply are not present.
Oracle records feature usage in a view that never forgets. What a developer touches on Free can become a per-processor line item the moment the database becomes Enterprise Edition.

AI Vector Search: The One Feature That Actually Crosses the Line for Free

There is genuine good news, and it is worth building on. AI Vector Search ships in the base 23ai database at no additional license cost, and that includes Free. Both editions include it. Developers can build semantic search and retrieval-augmented generation (RAG) prototypes on Free without triggering any additional entitlement. This is one of the few 23ai features where the free tier and the paid tier are genuinely equivalent at the license level.

The caveats are scale and scope. Vector Search is competitive with standalone vector databases only up to moderate scale (under roughly 10 million vectors); above that, dedicated platforms hold an advantage on raw query latency. And Select AI, the natural-language query capability, is currently available only on Autonomous Database, so it is not part of the self-managed Free or Enterprise Edition story. For the full breakdown, see our analysis of whether Vector Search is included or an extra and the pillar on what actually triggers an AI feature bill.

Enterprise Edition: The Price of Crossing the Line

When Free forces a move, Enterprise Edition is the destination for any workload that needs to scale beyond Standard Edition's caps or uses EE-only options. The list pricing has held steady into 2026, and it is unforgiving at scale.

Item List price Annual support (22%)
Enterprise Edition, per processor$47,500$10,450
Enterprise Edition, per Named User Plus$950$209
Partitioning option (per processor)$11,500$2,530
Real Application Clusters (per processor)$23,000$5,060
16-core Intel server, EE (16 × 0.5 core factor)$380,000$83,600
32-core Intel server, EE$760,000$167,200

Processor licensing uses physical cores multiplied by Oracle's core factor (0.5 for x86). A 16-core Intel server therefore requires 8 processor licenses at list, which is $380,000 plus $83,600 in annual support. Double the cores, double both figures. This is the arithmetic that turns a Free prototype into a capital decision.

The Named User Plus metric carries a trap: a 25 NUP-per-processor minimum on Enterprise Edition. That 16-core server licensed under NUP requires at least 16 × 0.5 × 25 = 200 NUP, roughly $190,000 at list, even if you have 50 actual users. NUP only wins for genuinely small, countable user populations on modest hardware. Note also that Multitenant allows up to 3 pluggable databases per container database at no extra option cost; beyond 3 PDBs, you license Multitenant separately.

Negotiated discounts of 40 to 70 percent are routine at volume in our experience, but the larger savings come from removing unused options and right-sizing the licensed processor count, not from the headline discount. Never accept a quote that licenses options you have not deployed.

Standard Edition 2: The Middle Path Most Buyers Skip

Between Free and Enterprise Edition sits Standard Edition 2 (SE2), and it is the cheapest legitimate way to run Oracle in production. List price is $17,500 per socket versus $47,500 per processor for EE. The trade-off is a hard hardware ceiling: a maximum of two populated CPU sockets per server and a 16-thread cap. Exceed the socket limit and SE2 cannot legally run on that server at all, which is a compliance cliff, not a soft warning.

Enterprise-only options (Partitioning, RAC in its full form, Advanced Compression, Diagnostics and Tuning Packs) do not run on SE2. SE2 also has a 10 NUP-per-server minimum. For a revenue-generating application that outgrows Free's 12GB but fits comfortably inside two sockets and 16 threads without needing EE options, SE2 is frequently the correct answer and often the one Oracle sales will not lead with. Compare the two paths in detail using our SE2 versus Enterprise Edition guide.

What Buyers Should Do

Draw the line deliberately and early. Free is for development and internal non-revenue tooling under 12GB. Anything customer-facing, revenue-linked, or requiring high availability moves to a paid edition, and the default first look should be SE2, not EE.

  • Fit development inside Free's caps, and treat the 12GB user-data ceiling (minus SYSAUX overhead) as your real design budget.
  • Disable AWR, ADDM, and management-pack usage on any Free instance destined for production promotion, then snapshot DBA_FEATURE_USAGE_STATISTICS before and after migration.
  • Build on AI Vector Search freely, since it is included at no extra cost, but validate your vector scale against the ~10 million vector threshold before committing architecture.
  • Default to SE2 for production that fits two sockets and 16 threads with no EE options; only escalate to EE when hardware scale or a specific option genuinely requires it.
  • When EE is unavoidable, right-size processor counts and strip unlicensed options before negotiating discount, then pursue 40 to 70 percent off the reduced footprint.
  • Run a formal license review before any migration off Free, because that is the only point where you control the entitlement baseline.

For adjacent 23ai feature decisions, review our analysis of True Cache licensing and in-database machine learning, both of which carry option-boundary questions similar to the ones above.

Frequently asked questions

Can I run Oracle 23ai Free in production?

Only in a narrow sense. Oracle permits limited low-scale, non-commercial production use, but the terms restrict revenue-generating production workloads, and Free is single-instance with no clustering or RAC and only basic backup. Any customer-facing or revenue-linked workload should run on a licensed edition (SE2 or EE). Read the actual license terms before deploying.

What are the exact resource limits on 23ai Free?

12GB of user data on disk, 2GB of RAM (a hard ceiling regardless of host memory), and 2 CPU cores or threads for foreground processes. It also allows only one installation per host, VM, or container, and caps pluggable databases at 16. Note that SYSAUX consumes part of the 12GB, so usable application data is less than the headline figure.

Is AI Vector Search free in 23ai, or does it cost extra?

AI Vector Search ships in the base 23ai database at no additional license cost, and that includes both Free and Enterprise Edition. You can build semantic search and RAG prototypes on Free without triggering an extra entitlement. It is competitive with standalone vector databases up to roughly 10 million vectors; above that, dedicated platforms hold a latency advantage.

How can Free edition create an audit liability later?

Oracle's views may show Enterprise Edition options as present even on Free, because they reflect code presence, not entitlement. Using features like AWR or ADDM on Free can be construed as Diagnostics Pack usage once the database is migrated to a commercial edition, and Oracle logs this in DBA_FEATURE_USAGE_STATISTICS. Disable pack usage and snapshot that view before and after any migration.

When should I choose SE2 instead of Enterprise Edition after outgrowing Free?

Choose SE2 when your production workload fits within two populated CPU sockets and 16 threads and does not require Enterprise-only options such as Partitioning, RAC, or the diagnostic packs. SE2 lists at $17,500 per socket versus $47,500 per processor for EE, so it is far cheaper. Escalate to EE only when hardware scale or a specific option forces it.

What does Enterprise Edition actually cost per server?

EE lists at $47,500 per processor, with processors counted as physical cores times the core factor (0.5 on x86). A 16-core Intel server needs 8 licenses, or $380,000 at list plus $83,600 in annual support at 22 percent. Named User Plus carries a 25-per-processor minimum, so it only saves money for genuinely small user counts on modest hardware.

Free White Paper

Stop overpaying for Oracle Database 23ai options

Oracle Database 23ai bundles options you may never deploy. The buyer side guide to edition right sizing, option pruning, and AI Vector Search licensing.

Gated with a work email on the download page. No sales follow up you did not ask for.

Get the White Paper →
Independent, buyer side. We never share your details with vendors.
Run a software spend health check against your Oracle estate in under five minutes.
Open the Tool →
Deep Library

More on this topic.

Oracle Hub →
Oracle Database 23ai Vector Search and AI Feature Licensing: What Actually Triggers a Bill
Oracle · Guide
Oracle Database 23ai Vector Search and AI Feature Licensing: What Actually Triggers a Bill
The full guide this article belongs to.
Guide
Is Oracle 23ai AI Vector Search Included in Enterprise Edition or an Extra?
Oracle · Deep dive
Is Oracle 23ai AI Vector Search Included in Enterprise Edition or an Extra?
Another angle on the same decision.
Guide
Oracle 23ai In-Database Machine Learning: The Advanced Analytics License Question
Oracle · Deep dive
Oracle 23ai In-Database Machine Learning: The Advanced Analytics License Question
Another angle on the same decision.
Guide
Oracle Database 23ai Licensing Guide. Enterprise framework.
Oracle
Oracle Database 23ai Licensing Guide. Enterprise framework.
Oracle Database 23ai decoded. AI Vector Search included in EE, Spatial moved into base, th
Guide
Oracle Database editions. Enterprise or Standard.
Oracle
Oracle Database editions. Enterprise or Standard.
Oracle Database Enterprise Edition scales without limit, while Standard Edition 2 is far c
Guide
Oracle SE2 vs Enterprise Edition: Limits, Metrics, and When Each Wins
Oracle
Oracle SE2 vs Enterprise Edition: Limits, Metrics, and When Each Wins
Oracle Standard Edition 2 versus Enterprise Edition compared: socket limits, the NUP and p
Guide
Editorial boardroom interior

The advisor your vendors do not want.

500+ enterprise clients. 11 vendor practices. Industry recognized. One conversation can change what you pay for the next three years.

Stay ahead of Oracle licensing changes.

One buyer side briefing a week. Renewal signals, audit moves, and the levers that work. No vendor spin.