On AWS RDS, the licensing math is different: every deployment stands on its own, and EE BYOL requires enough processor licenses to cover the instance’s vCPU count at Oracle’s cloud licensing policy rates.
For many Oracle OLTP workloads, transactional applications, reporting databases, backend data stores the EE-only features are not used and SE2 is technically sufficient. The assessment is the job.
The short answer
SE2 may be sufficient when the database does not use partitioning, the Diagnostics or Tuning Pack, Advanced Security Option features, or more than three user-created PDBs, and runs within 16 vCPUs.A requirement for more than three PDBs needs appropriate Enterprise Edition and Oracle Multitenant licensing; a requirement for Database Vault makes Amazon RDS an unsuitable target because RDS does not support Database Vault.
That is a starting point, not a verdict. Your existing license position and how much your DBAs rely on AWR data can change which option is cheaper, so run the eligibility check against the database’s own feature-usage data first.
Oracle EE vs SE2: Full Feature Comparison
Verdict first: SE2 is sufficient and significantly cheaper when no EE-only feature applies. The comparison below identifies clear SE2 disqualifiers; it does not establish full migration eligibility. If a listed EE-only feature is required, retain EE, redesign the workload, or use a deployment model that supports it.If none applies, validate application certification, enabled RDS options, migration constraints, and Oracle licensing before selecting SE2. For comparable BYOL deployments, the underlying RDS infrastructure rate is the same for the same instance class.
| Feature or constraint | SE2 | EE |
|---|---|---|
| — Licensing & instances — | ||
| Max vCPUs (concurrent threads) | 16 (hard limit) | Unlimited |
| License Included (LI) on RDS | Yes | No, BYOL only |
| Bare metal BYOL on RDS | Yes (Jan 2026) | Yes (Sep 2025) |
| Oracle list price | ~$17,500/socket | ~$47,500/processor |
| — Performance & tuning — | ||
| Diagnostics Pack (AWR, ADDM, ASH) | Not available | Separately licensed option |
| Tuning Pack (SQL Tuning Advisor) | Not available | Separately licensed option |
| — Security — | ||
| Advanced Security Option (TDE, Data Redaction) | Not available | Separately licensed option |
| Label Security / Database Vault | Not available | Label Security: separately licensed; Database Vault: not supported on Amazon RDS |
| — Data & availability — | ||
| Table and index partitioning | Not available | Separately licensed option |
| Oracle Multitenant (PDBs) | Max 3 | Up to 30 tenant databases on RDS, subject to configuration and licensing; more than 3 requires the separately licensed Oracle Multitenant option |
| Oracle read replicas (Active Data Guard) | Not supported | Supported (BYOL + ADG license) |
SE2 or EE: The 4-Question Check
| # | Question | Yes | No |
|---|---|---|---|
| 1 | Does the database have partitioned tables or indexes in use? | Stop: EE with the separately licensed Oracle Partitioning option is required, unless the partitioned objects are redesigned. | Continue |
| 2 | Does it use AWR, ADDM, ASH, SQL Tuning Advisor, ASO, Label Security, or Database Vault? | Stop: SE2 is insufficient for the listed EE-only features. If Database Vault is required, Amazon RDS is unsuitable because it does not support Database Vault. | Continue |
| 3 | Does it require more than 3 PDBs? | Stop: SE2 is insufficient; more than 3 PDBs require EE with the separately licensed Oracle Multitenant option. | Continue |
| 4 | Does P95 CPU consistently exceed 70% on 16 vCPUs, with no memory-preconfigured instance class viable? | Assess capacity, tuning, and memory options; EE may be required | SE2 is sufficient |
No partitioning in use
No partitioned tables or indexes.
No Diagnostics or Tuning Pack
No AWR, ADDM, ASH, or SQL Tuning Advisor.
No Advanced Security features
No ASO, Label Security, or Database Vault.
Within 3 PDBs and 16 vCPUs
Database requirements stay within the SE2 PDB and compute limits.
Confirming SE2 Eligibility: The Key Queries
Check your current edition first:SELECT NAME, DETECTED_USAGES, CURRENTLY_USED, LAST_USAGE_DATE
FROM DBA_FEATURE_USAGE_STATISTICS
WHERE DETECTED_USAGES > 0
ORDER BY LAST_USAGE_DATE DESC;
- Partitioning (any usage means partitioned objects exist)
- Diagnostics Pack (any AWR-related features)
- Advanced Security, Label Security, Database Vault, In-Memory
The Diagnostics Pack and Tuning Pack Trap
This is the most common reason organizations incorrectly believe they require EE and the most common compliance risk after migrating to SE2.The Diagnostics Pack includes:
- Automatic Workload Repository (AWR)
- Automatic Database Diagnostic Monitor (ADDM)
- Active Session History (ASH)
- SQL Tuning Advisor
- SQL Access Advisor and Automatic SQL Tuning
In an Oracle audit, AWR data found on an SE2 database is treated as unlicensed Diagnostics Pack usage even if it was generated accidentally.
Check whether collection is active:
WHERE NAME = 'control_management_pack_access' ;
The practical test: if your DBAs depend on AWR data daily, factor in the cost of replacing that workflow before the license savings calculation means anything.
When the SE2 16-vCPU Limit Binds
SE2 caps each database at 16 concurrent CPU threads on RDS, a hard limit of 16 vCPUs. The largest SE2-eligible virtualized classes are the 4xlarge sizes: db.r7i.4xlarge, db.r8i.4xlarge, db.m6i.4xlarge, and similar (supported RDS for Oracle instance classes).Most OLTP Oracle databases don’t saturate 16 vCPUs. The limit binds for: high-concurrency workloads that connection pooling can’t reduce, parallel analytics aggregations, aggressively parallel batch processing, and databases that have organically outgrown 16 vCPUs at steady state.
The diagnostic (a planning heuristic, not an AWS or Oracle licensing rule): pull CPUUtilization from CloudWatch for 30 days.
- P95 consistently above 70% on 16 vCPUs → SE2 is likely insufficient.
- P95 below 50% (even on a large EE instance) → SE2 would handle the load.
SE2 or EE: The 4-Question Check
| Component | EE BYOL | SE2 License Included | SE2 BYOL |
|---|---|---|---|
| AWS compute (db.r6i.xlarge, on-demand) | ~$0.50/hr | ~$0.952/hr | ~$0.50/hr |
| Oracle license | EE ~$47,500/processor (existing) | $0 bundled | SE2 ~$17,500/socket (existing) |
| Oracle SULS | ~22%/yr | None, AWS handles support | ~22%/yr |
| EE features | Yes | No | No |
| 16-vCPU cap | No | Yes | Yes |
| Best for | Workloads requiring EE features | New deployments, no existing licenses | Existing SE2 licenses on active SULS |
| Cost component | EE BYOL | SE2 LI | SE2 BYOL |
|---|---|---|---|
| AWS compute/yr | ~$4,380 | ~$8,340 | ~$4,380 |
| Oracle license (list) | $95,000 (2 processors) | Included | ~$17,500 (1 socket) |
| SULS/yr | ~$20,900 | None | ~$3,850 |
| Estimated Year 1 total | ~$120,280 | ~$8,340 | ~$25,730 |
SE2 LI is the lowest Year-1 cost with no existing licenses and zero Oracle procurement overhead.
SE2 BYOL is cheapest over a multi-year horizon on existing licenses with active SULS.
EE BYOL costs ~$94,550 more in Year 1 than SE2 BYOL here (one-time license plus ~$17,050/yr recurring SULS delta) it only makes sense when EE features are genuinely required.
Also read: RDS Extended Support Pricing: Oracle and MySQL version costs
SE2 BYOL Bare Metal: 25% Compute Savings
AWS extended bare metal support to Oracle SE2 BYOL in January 2026 (EE followed the September 2025 launch), at 25% lower cost than equivalent virtualized instances. Most bare metal instances have 2 sockets, while db.m7i.metal-24xl and db.r7i.metal-24xl each have a single socket relevant because SE2 is licensed per socket.The SE2 16-thread cap still applies per database; the value is the compute discount and consolidating multiple SE2 databases as PDBs on one instance.
Full bare metal economics and license-consolidation analysis: RDS Oracle BYOL guide.
How Usage.ai Optimizes Oracle RI Purchasing
Which edition and licensing model you land on changes what you should buy: SE2 License Included RIs are exact-size, while SE2 BYOL and EE BYOL RIs are size-flexible through normalization units. RI strategy for both models: RDS Oracle Reserved Instances: BYOL, License-Included and the Hidden Costs.We identify Oracle BYOL instances separately from LI instances and apply size-flexible RI purchasing to the BYOL side. For LI instances, we surface right-sizing opportunities before any RI purchase, since a wrong-sized LI RI can’t adjust through normalization.
With Flex Insured Commitments, teams can get the 30–40% savings of a 1-year commitment with none of the commitment risk.
If eligible usage drops and a qualifying Flex Commitment ends up costing more than the on-demand rate for that usage, we provide cashback protection on that difference, subject to program terms.
Our fee is a percentage of realized savings only if we don’t save you money, you don’t pay anything.
Upload your AWS bill. No account access or commitment required.
Frequently asked questions
Can I use AWR reports on an Oracle SE2 database?
No. AWR is part of the Diagnostics Pack, which requires EE plus a separate license. Running it on SE2 even accidentally via OEM is a compliance violation. Disable with ALTER SYSTEM SET control_management_pack_access = 'NONE'; and use Oracle Statspack or CloudWatch Database Insights instead.
What is the 16-vCPU limit for Oracle SE2 on RDS?
SE2 is limited to 16 concurrent CPU threads per database. The largest SE2 virtualized classes are 4xlarge sizes such as db.r7i.4xlarge and db.r8i.4xlarge. Memory-preconfigured classes (e.g. db.r7i.4xlarge.tpc2.mem4x) provide more memory within the 16-vCPU limit.
Can I downgrade from Oracle EE to SE2 on RDS?
Yes, if no EE-only features are in active use. Query
DBA_FEATURE_USAGE_STATISTICS, verify CPU fits 16 vCPUs, disable control_management_pack_access, validate object dependencies and your Oracle licensing position, then migrate to a new SE2 instance.
Is Oracle Partitioning available in SE2?
No. Partitioning is EE-only. Query DBA_TAB_PARTITIONS and DBA_IND_PARTITIONS to count partitioned objects; they must be converted to non-partitioned equivalents before any SE2 migration.
What is the SE2 BYOL bare metal option on RDS?
Launched January 2026, bare metal SE2 BYOL instances cost 25% less than equivalent virtualized instances and expose physical core and socket counts, which may allow license optimization. The 16-thread cap still applies. Source: AWS announcement, January 20, 2026.