A fully optioned Oracle Database Enterprise Edition processor licence costs $122,000 at list with $26,840 annual support, 2.6 times the cost of the base Database licence on its own. Most Oracle audit findings target option usage, not base Database deployment. This reference catalogues every Database option and management pack with 2026 list prices, audit-finding frequency, and the technical guardrails that prevent unintended usage. Use it to validate your option footprint before Oracle's LMS team does.
Oracle Database options follow a strict pricing rule: each option is priced per the same metric as the underlying Database licence. If Database is licensed per processor at $47,500, Partitioning is licensed per processor at $11,500. If Database is licensed per Named User Plus at $950, Partitioning is licensed per NUP at $230. The minimum NUP per processor rule applies to options as well as Database, so a 16-core Intel server with Partitioning enabled requires a minimum of 200 NUP licences for Partitioning, equivalent to $46,000 at list.
Performance options: Diagnostics, Tuning, In-Memory
The performance option group is the most commonly audited because the usage is easy for Oracle to detect through automatic feature tracking in the database. Three options dominate.
Diagnostics Pack ($7,500 per processor, $150 per NUP) provides Automatic Workload Repository (AWR) reports, Automatic Database Diagnostic Monitor, and Active Session History. Any DBA who runs an AWR report on an unlicensed database creates a compliance event. The fix is either to license Diagnostics on every database or to set the initialisation parameter CONTROL_MANAGEMENT_PACK_ACCESS to NONE on databases that do not require it.
Tuning Pack ($5,000 per processor, $100 per NUP) provides SQL Tuning Advisor, SQL Access Advisor, and Real-Time SQL Monitoring. Tuning Pack requires Diagnostics Pack as a prerequisite. Auditors detect Tuning Pack usage through the DBA_FEATURE_USAGE_STATISTICS view.
Database In-Memory ($23,000 per processor, $460 per NUP) provides the column store accelerator for analytics workloads on Database 12c and later. Usage is detected through the V$IM_SEGMENTS view. Unlike Diagnostics, In-Memory cannot be enabled accidentally; it requires explicit initialisation parameter changes and segment-level INMEMORY clauses.
Security options: Advanced Security, Database Vault, Label Security
Security options carry higher list prices because they address compliance-driven deployments where the customer has no realistic alternative.
Advanced Security ($15,000 per processor, $300 per NUP) provides Transparent Data Encryption (TDE) and Data Redaction. TDE is required for PCI-DSS, HIPAA, and many GDPR-aligned deployments. Customers who enable TDE for compliance reasons are committed to the option for the database's life.
Database Vault ($11,500 per processor, $230 per NUP) provides realm-based access control that prevents DBAs from accessing application data. Database Vault is required for certain regulated industries that mandate separation of duties between database administrators and data owners.
Label Security ($11,500 per processor, $230 per NUP) provides row-level security based on classification labels. Government, defence, and intelligence deployments are the primary customer base.
High availability and disaster recovery options
Real Application Clusters (RAC) ($23,000 per processor, $460 per NUP) is the most expensive single Database option and the most operationally significant. RAC provides active-active database clustering. Every node in a RAC cluster requires a full RAC licence plus Database Enterprise Edition. A two-node RAC cluster on 16-core servers requires 32 processor licences each for Database EE and RAC, equivalent to $2.26M at list before discounts.
Active Data Guard ($11,500 per processor, $230 per NUP) extends Oracle Data Guard to allow read-only access on the standby database. Basic Data Guard is included in Database Enterprise Edition. Active Data Guard is required to query the standby. Audit-finding frequency is high because many customers enable Active Data Guard for reporting workloads without licensing it.
| Option / Pack | Processor list | NUP list | Audit-finding frequency |
|---|---|---|---|
| Diagnostics Pack | $7,500 | $150 | Very high (85 percent of audits) |
| Tuning Pack | $5,000 | $100 | High (65 percent) |
| Partitioning | $11,500 | $230 | High (60 percent) |
| Advanced Compression | $11,500 | $230 | Medium (45 percent) |
| Advanced Security | $15,000 | $300 | Medium (40 percent) |
| Real Application Clusters | $23,000 | $460 | Low (15 percent, typically licensed) |
| Active Data Guard | $11,500 | $230 | High (55 percent) |
| Database Vault | $11,500 | $230 | Low (10 percent) |
| Label Security | $11,500 | $230 | Very low (5 percent) |
| Multitenant (beyond 3 PDBs) | $17,500 | $350 | Medium (35 percent) |
| Database In-Memory | $23,000 | $460 | Low (20 percent) |
| Spatial and Graph | $17,500 | $350 | Medium (30 percent) |
| Cloud Management Pack | $7,500 | $150 | High (50 percent) |
Data management options: Partitioning, Compression, Multitenant, Spatial
Partitioning ($11,500 per processor, $230 per NUP) provides table and index partitioning. Partitioning is one of the highest-frequency audit findings because DBAs use it for performance optimisation on large tables without recognising it requires a separate licence. The DBA_PART_TABLES view records every partitioned table, and Oracle LMS examines it during every audit.
Advanced Compression ($11,500 per processor, $230 per NUP) provides table compression, index compression, and backup compression. Compression usage is recorded in the DBA_TABLES view and DBA_FEATURE_USAGE_STATISTICS. Many customers enable compression for storage reduction without budgeting for the licence.
Multitenant ($17,500 per processor, $350 per NUP) is required for more than three pluggable databases (PDBs) per container database (CDB). Up to three PDBs are free under the Database Enterprise Edition licence. The fourth PDB triggers Multitenant licensing for the entire CDB and every container that hosts more than three PDBs.
Spatial and Graph ($17,500 per processor, $350 per NUP) provides geospatial and graph processing. Usage is detected through specific PL/SQL package executions. Many customers enable Spatial features through application code without recognising the licence requirement.
The DBA_FEATURE_USAGE_STATISTICS trap: Oracle's automatic feature tracking captures every option ever used on every database, including a single test query that ran two years ago. The view retains usage history for the database's life. Oracle LMS auditors examine this view as standard practice. Customers who have used options inadvertently are commonly asked to license those options retroactively from the first detected use, plus 22 percent support compounded. The remediation is to identify inadvertent usage early, document the usage pattern, and either purchase the option, remove the feature, or negotiate a usage exclusion at the next contract event.
Management packs
Oracle's management packs are required for Oracle Enterprise Manager (OEM) features. Cloud Management Pack for Database ($7,500 per processor) is required to use OEM Cloud Control for database management. Many customers deploy OEM Cloud Control as a free administrative tool without recognising that several core features (provisioning, configuration management, performance management) require the Management Pack.
Additional management packs include the WebLogic Management Pack ($10,000 per processor), the Configuration Management Pack ($7,500 per processor), the Lifecycle Management Pack ($7,500 per processor), and the Database Lifecycle Management Pack ($7,500 per processor). The functional overlap among these packs is significant, and customers commonly need only one to two of them.
Technical guardrails to prevent unintended usage
Three technical controls prevent the most common unintended option usage. First, set CONTROL_MANAGEMENT_PACK_ACCESS to NONE in the database initialisation parameters where Diagnostics and Tuning Pack are not licensed. This blocks AWR and ADDM functions at the database level. Second, restrict DBA role assignments and use a feature-control workflow that requires architectural review before any option-related feature is enabled in production. Third, run a quarterly DBA_FEATURE_USAGE_STATISTICS audit against the licensed option list and remediate divergence before it accumulates.
For customers in active audit, the remediation framework is structured: identify all inadvertent usage, document the usage pattern, evaluate whether to license the option or remove the feature, and negotiate the LMS finding against the documented remediation. See Oracle audit defence for the complete LMS engagement playbook.
Cost modelling for fully optioned environments
For an enterprise Oracle estate with 200 processor licences across production, staging, dev, and DR, a fully optioned configuration including Database EE, RAC, Partitioning, Advanced Compression, Advanced Security, Diagnostics, Tuning, and Active Data Guard lists at $122,000 per processor or $24.4M total, plus $5.37M annual support. Typical large-customer discounts (55 to 75 percent) reduce the net cost to roughly $9.8M to $14.6M with $2.16M to $3.21M annual support.
The cost-control levers are option rationalisation (remove options not required for the workload), metric optimisation (use NUP where users are countable), and contract-level option bundling at renewal (negotiate an option-inclusive Database licence rather than per-option line items). See Oracle licensing costs 2026, Oracle Database licensing, Oracle renewal strategy, and complete Oracle licensing guide. For an engagement on option remediation, see software licensing advisory or the Oracle vendor hub.