Home/Oracle Hub/White Papers/Oracle Database Options and Management Packs
Oracle Database  |  Options and Management Packs White Paper

The Hidden Bill: Oracle Database Options and Management Packs

On a licensed Enterprise Edition database, the options and management packs bolted on top routinely cost more than the database itself, and the two most dangerous line items switch themselves on by default.

Prepared by Redress Compliance · July 2026 · Oracle licensing advisory. Representative Oracle estate scenario (benchmark scenario, not a quote). List prices per the Oracle Technology Global Price List.

Executive summary

Enterprise Edition is the entry ticket, not the bill. Every priced option and management pack you deploy licenses on the same processor count as the database beneath it, so the cost of the estate is decided by which options run, not by the base licence alone.

On a representative 8 processor Enterprise Edition database, the base lists at $380,000. Add the four components we most often find running — Partitioning, Advanced Compression, Advanced Security, and the Diagnostics and Tuning packs — and the options and packs add $404,000, more than the database they sit on.

The most dangerous items are the two cheapest. The Diagnostics Pack at $7,500 per processor and the Tuning Pack at $5,000 per processor switch on through Enterprise Manager, AWR, and the automatic advisors, generating usage no one chose to license. Independent estimates put accidental Diagnostics and Tuning usage in roughly four of ten Enterprise Edition estates.

Oracle measures usage, not intent. The database records first use of every option in DBA_FEATURE_USAGE_STATISTICS, an audit script reads it, and a single partitioned table created once becomes a Partitioning liability that never expires.

The your side answer is not to license everything defensively. It is to strip and prove: inventory feature usage, disable what is not licensed and not needed, and hold a documented map of what runs where. Across the estates we reviewed, this recovered option and pack liability an audit would otherwise have priced at list.

This paper gives the price table, the worked stack on a real database, the mechanics of accidental usage, the five findings that recur in an Oracle review, and the sequence to close the exposure before an audit letter arrives.

$380,000
Enterprise Edition base licence, 8 processor benchmark database, at list
$404,000
The four common options and packs added on top of that base — more than the database itself
~40%
Share of Enterprise Edition estates carrying accidental Diagnostics or Tuning Pack usage
$12,500
Per processor cost of the Diagnostics + Tuning packs — the two that auto-enable
1.

Why the base licence is only the entry ticket

Oracle Database Enterprise Edition is licensed per processor at a list price of $47,500. That number is where most clients stop reading, and it is where the real bill begins. Enterprise Edition ships with the engine, but the capabilities that make it worth deploying — partitioning large tables, encrypting data at rest, compressing storage, monitoring performance, running an active standby — are separately licensed options and management packs, each with its own per processor price.

The rule that governs the whole category is short: every option and pack licenses on the same processor count as the database it runs on. If the database is licensed at 8 processors, Partitioning is licensed at 8 processors, the Diagnostics Pack is licensed at 8 processors, and so on. There is no partial metric. You cannot license Partitioning on the two cores that hold partitioned tables; you license it on every processor of the database.

That single rule is why an Oracle estate rarely costs what the base licence suggests. The options are not add ons in the commercial sense of a small upsell. They are full price multipliers layered on the same footprint.

The commercial design is deliberate. Enterprise Edition is priced to be an attainable entry point, and the capabilities that make a serious production database — partitioning a large table, encrypting sensitive columns, running an active standby, monitoring performance properly — are unbundled into separately priced options. A client who evaluates Oracle on the base licence alone is comparing the wrong number, because the estate they will actually run needs several of those options, each at full processor price and each carrying its own support line.

The your side reading. Treat the base Enterprise Edition price as the smallest number in the conversation. The estate cost is set by the options and packs that run on top of it, and most of them are optional in name only because they are switched on by default.
2.

The two families: options and management packs

The catalogue splits into two families. Database options extend the engine — scaling, availability, security, storage. Management packs extend Enterprise Manager — monitoring, diagnosis, tuning, lifecycle. Both license per processor on the full database footprint. The table below lists the per processor list prices for the components we most often find in enterprise estates.

ComponentFamilyList, per processorWhat it does
Real Application ClustersOption$23,000Active-active clustering across nodes
Database In-MemoryOption$23,000Columnar in-memory analytics
MultitenantOption$17,500Pluggable database consolidation
Advanced SecurityOption$15,000Transparent Data Encryption and redaction
PartitioningOption$11,500Table and index partitioning
Advanced CompressionOption$11,500Storage and backup compression
Active Data GuardOption$11,500Readable, queryable standby
Database VaultOption$11,500Privileged-user separation of duties
Label SecurityOption$11,500Row-level classification control
Diagnostics PackPack$7,500AWR, ADDM, performance monitoring
Cloud Management PackPack$7,500Enterprise Manager cloud automation
Tuning PackPack$5,000SQL Tuning Advisor, SQL profiles

Annual support runs at 22 percent of the net licence on every line, so an option is not a one time cost. It is a licence plus a support annuity that compounds for the life of the deployment. The Tuning Pack at $5,000 per processor looks trivial next to the $47,500 base; on an 8 processor database it is a $40,000 licence and an $8,800 per year support line, for a component that a single advisor click can enable.

3.

How four components stack on one database

The clearest way to see the hidden bill is to build it up on a single database. Take a representative Enterprise Edition database licensed at 8 processors. The base is $380,000. Now add the four components we most often find already running, none of which the client typically set out to license.

LinePer processor× 8 processorsCumulative
Enterprise Edition base$47,500$380,000$380,000
+ Partitioning$11,500$92,000$472,000
+ Advanced Compression$11,500$92,000$564,000
+ Advanced Security$15,000$120,000$684,000
+ Diagnostics Pack$7,500$60,000$744,000
+ Tuning Pack$5,000$40,000$784,000
Options and packs subtotal $404,000$784,000 total

The options and packs add $404,000 to a database whose base licence is $380,000. The add ons cost more than the database. And this is a conservative stack — it excludes Real Application Clusters, In-Memory, and Multitenant, any one of which would push the options past twice the base.

$0 $200k $400k $600k $800k $380k EE base $472k + Partn. $564k + Compr. $684k + Adv Sec $744k + Diag. $784k + Tuning Base & options Auto-enabling packs

Cumulative licence on an 8 processor benchmark database, at list. Numbers match the table above. Benchmark scenario, not a quote.

Set side by side, the two totals make the point that gives this paper its title. The database is the smaller number.

$0$150k$300k$450k $380kEnterprise Edition base $404kOptions & packs on top Options exceed the database

The four common options and packs cost more than the Enterprise Edition licence they sit on. Benchmark scenario, not a quote.

4.

The accidental-usage trap: how packs switch themselves on

The reason this bill is hidden, rather than merely large, is that the most expensive habits are defaults. Three mechanisms generate option and pack usage that no one deliberately licensed.

Oracle does not need to guess whether you used an option. The database keeps the record. DBA_FEATURE_USAGE_STATISTICS and the options and packs usage views log first and last use of every tracked feature, and the standard Oracle License Management Services review reads exactly those views. A feature used once, years ago, on a database since rebuilt, still shows in the history and still supports a claim.

The your side reading. Accidental usage is the single largest avoidable Oracle exposure. Independent reviews put unlicensed Diagnostics or Tuning usage in roughly 40 percent of Enterprise Edition estates, almost always from defaults rather than intent. The fix is a feature usage inventory before an audit, not after.

5.

What is actually free, and what 23ai changes

Not every capability is a paid option, and knowing the line matters because paying for something bundled is as wasteful as running something unlicensed.

CapabilityIncluded in Enterprise EditionSeparate paid option
Table compressionBasic compressionAdvanced Compression, for OLTP and backups
Network encryptionNative network encryptionAdvanced Security, for TDE at rest and redaction
Standby databaseBasic Data Guard (mounted)Active Data Guard, for a readable standby
Pluggable databasesA small number on recent releasesMultitenant, for consolidation at scale
Performance monitoringManual, scripted viewsDiagnostics Pack, for AWR and ADDM

The discipline is symmetrical: strip what you run but do not need, and stop paying for what the edition already includes. Clients routinely license Advanced Compression where basic compression covers the requirement, or Advanced Security where native network encryption already meets the control, so the free-versus-paid line is worth walking as carefully as the accidental-usage line.

6.

Where the common advice on options is wrong

The standard advice, often from the reseller, is to license the options broadly so you are never caught short in an audit. We disagree, and the engagement file backs it.

Across the Oracle estates our team reviewed, the majority carried at least one option or pack that was licensed or in use but delivered no workload value — a Tuning Pack no one ran deliberately, Partitioning on a database with no partitioned tables in production, Advanced Security bought for a compliance requirement that native encryption already met. Licensing defensively converts a fixable configuration issue into a permanent cost annuity plus 22 percent support every year.

The counter move is strip and prove. Inventory actual feature usage from the database views, disable the options and packs that are not licensed and not needed, document the configuration, and license only what the workload genuinely requires. This shrinks the footprint an audit can price, and it does so from evidence rather than fear.

A database administrator reviewing Oracle feature usage statistics on screen in a data center operations room
Option cost turns on what the database actually uses, not what is installed. The feature usage views decide the audit before the auditor does.
7.

The five findings that recur in an Oracle review

Five option and pack findings appear again and again, and each has a your side answer that is set before an audit, not argued after one.

FindingWhat Oracle testsYour side answer
Accidental Diagnostics / TuningAWR and advisor usage without a licenceSet control_management_pack_access; confirm before the snapshot
Partitioning first useAny partitioned object, ever, in feature historyInventory partitioned objects; remove or license deliberately
Options installed but unlicensedOptions linked into the binary and usedDeinstall unused option binaries where the workload allows
Full-footprint countingOption on every processor of the databaseConsolidate option-heavy workloads onto a bounded footprint
Paying for bundled featuresNot a compliance risk — a waste findingDrop Advanced options the edition or native features already cover

The first two are compliance exposures that cost money in an audit. The last two are waste findings that cost money every year regardless of an audit. A proper review closes both directions.

8.

The cloud twist: options do not get cheaper

Moving the database to AWS, Azure, or OCI does not dissolve the options question; it re-bases it. On an authorized cloud environment the processor count is taken from vCPUs under Oracle's cloud policy, and every option still licenses on that same processor count. The on premises core factor that halves x86 counts does not apply in the cloud, so a lift and shift can quietly raise the option bill even as the hardware line falls.

The one structural relief is the managed and license included cloud services, where some options are folded into the service rate. That is a genuine lever, but it trades a licence you own for a rate you rent, and the comparison has to be modelled per workload. Our companion paper, the Oracle on Azure and AWS BYOL Field Guide, works the cloud counting math in full.

106%
Options as a share of the base

On the benchmark 8 processor database, the four common options and packs cost more than the Enterprise Edition licence they sit on. Benchmark scenario, not a quote.

22%
Annual support on every line

Each option and pack carries a support annuity at 22 percent of net licence, so an unused option costs money every year it stays on the contract.

The cloud does not change the discipline, only the counting basis. Whether the database runs on a physical server, a hard partition, or a cloud instance, the options license on the processor count that governs it, and the strip and prove work — read the usage, disable what is unlicensed, document the rest — is identical. A lift and shift is in fact the ideal moment to do it, because the estate is being inventoried anyway and the unused options can be left behind rather than carried into the new footprint at a now-higher cloud count.

Oracle does not audit what you meant to use. It audits what the database recorded. The feature usage views are written before the auditor arrives, so the client who reads them first controls the finding.
9.

What should you do next?

The exposure closes on a short, ordered sequence. None of it requires a negotiation with Oracle; all of it is work the customer controls, and it follows the strip and prove logic end to end.

Step 1

Read the usage

Pull DBA_FEATURE_USAGE_STATISTICS and the options usage views across every Enterprise Edition database, before any Oracle engagement.

Step 2

Strip what you can

Disable options and packs you run but do not need, and set control_management_pack_access to stop the Diagnostics and Tuning packs re-enabling.

Step 3

Prove and consolidate

Document the configuration, consolidate option-heavy workloads onto a bounded footprint, and license only the capability the workload genuinely uses.

Our recommendation: inventory feature usage, strip the options and packs you run but do not need, lock the access controls that stop the packs re-enabling, and license only the capability the workload genuinely requires.

  • Read the feature usage views first. Pull DBA_FEATURE_USAGE_STATISTICS and the options usage views across every Enterprise Edition database. That report is what an Oracle review will read, so read it before they do.
  • Set control_management_pack_access. Setting this parameter to NONE or DIAGNOSTIC stops the Diagnostics and Tuning packs generating usage, closing the single most common accidental exposure.
  • Consolidate option-heavy workloads. Because options license on the full footprint, moving partitioned or encrypted workloads onto a bounded, deliberately licensed database is often cheaper than spreading them across the estate.