Editorial photograph of an enterprise data center server aisle during a database licensing review
Oracle / Database

Oracle Database EE options. Pricing and the audit trap.

Enterprise Edition options are licensed separately from the database, priced per processor or per Named User Plus. They drive most Oracle audit findings. Read the pricing and the buyer moves before the next LMS script lands.

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

Oracle Database Enterprise Edition options carry separate license fees on top of the database. Most audit findings trace back to options used but never purchased. This guide covers pricing, the core factor, the options that invite findings, and the buyer moves that cut exposure.

Key takeaways

  • Enterprise Edition options and management packs are licensed separately from the database engine.
  • Per processor pricing multiplies the list price by the core count and the Oracle core factor.
  • Named User Plus is the alternative metric, with a minimum count per processor.
  • Most option findings come from features switched on by default in tools, not by a project decision.
  • Diagnostics Pack and Tuning Pack usage inside Enterprise Manager is the single most common finding.
  • A feature usage baseline removes the surprise before Oracle ever asks for one.
  • The cheapest time to fix an option gap is at renewal, never inside an open audit.

Oracle Database Enterprise Edition is the base product. The options and management packs sit on top and each one is a separate purchase. Buying the database does not entitle you to Partitioning, Advanced Security, or the diagnostic packs.

That separation is where the money hides. A feature can be one click away inside a console, yet that click can create a six figure license gap. The buyer job is to know which clicks cost money.

What are Oracle Database Enterprise Edition options and how are they priced?

Enterprise Edition options extend the database with capabilities like partitioning, in memory processing, and security controls. Management packs add monitoring and tuning. Both are priced on the same metrics as the database itself.

The option and management pack catalog

The catalog is long, but a handful of items drive almost every finding. Know these before any project enables a feature.

  • Partitioning: splits large tables for performance, and is the most widely used paid option.
  • Diagnostics Pack and Tuning Pack: performance monitoring and advisors, often on by default in Enterprise Manager.
  • Advanced Security: transparent data encryption and redaction, common in regulated estates.
  • Advanced Compression: storage and backup compression that is easy to enable silently.
  • Real Application Clusters: active clustering for high availability, licensed per node.
  • Active Data Guard: read access on a standby database, a frequent surprise on disaster recovery sites.

How does per processor pricing and the core factor work?

Per processor is the default server metric. You multiply the physical core count by the Oracle core factor, then by the list price of each option. The published rates live in the Oracle Technology Price List.

The core factor varies by chip. Most modern Intel and AMD cores carry a factor of 0.5, which the Oracle Processor Core Factor Table defines. A 32 core server therefore counts as 16 processor licenses for each option deployed on it.

When does Named User Plus beat per processor?

Named User Plus counts people and devices that access the database. It carries a minimum count per processor, defined in the Database Licensing Information User Manual.

For small, fixed user populations, Named User Plus is cheaper. For large or unknown populations, per processor wins. The break even point is the decision, not the default.

Common Enterprise Edition options and where the risk sits

Option or pack What it does Why it triggers findings
PartitioningSplits large tablesEnabled by DBAs for performance without a purchase
Diagnostics PackPerformance monitoringOn by default in Enterprise Manager
Tuning PackSQL advisorsOne click access inside the console
Advanced CompressionStorage compressionEasy to switch on per table
Active Data GuardReadable standbyStandby opened read only on recovery sites
Cover of the Redress Compliance Oracle buyer side white paper

White Paper ยท Oracle

The Oracle Buyer Side Framework

The moves we use across Oracle Database, Java and ULA estates. Read it free.

Read the white paper

Why do Database EE options trigger Oracle audit findings?

Options drive findings because they are easy to use and hard to track. The database records that a feature was touched, even once, and Oracle reads that record during an audit.

Which features activate without a purchase order?

Several high value features are reachable by any administrator with no warning that they cost money. A single test of a partitioned table or a compression run leaves a permanent usage flag.

Oracle License Management Services queries those flags through scripts. The flag does not know whether the use was a project or an accident.

How does Enterprise Manager create Diagnostics and Tuning findings?

Enterprise Manager ships with the performance pages active. Opening the performance hub, the AWR report, or the SQL advisors counts as Diagnostics or Tuning Pack use.

Teams click these pages daily without knowing they are paid. The fix is to disable the management packs in Enterprise Manager unless they are licensed.

Where the common advice on Database options is wrong

The standard reseller line is that you should license every option you might ever touch, to stay safe. We disagree. In roughly seven out of ten estates we baseline, the buyer is paying for or being chased on options that no production workload actually needs. The buyer side move is the reverse. Measure real usage first, turn off the packs that are merely default, isolate the few options a workload depends on, and license only those. Breadth is not safety. Breadth is just a larger bill that the next audit will still try to grow.

Editorial photograph of a finance and IT team reviewing Oracle database usage reports on a shared screen
A feature usage baseline turns an audit from an interrogation into a checklist. The estates that hold their settlement low are the ones that walked in already knowing their own numbers.
45
Database audits defended 2024 to 2025
65%
Share of exposure from options not the engine
42%
Median reduction from opening claim

Source: Redress Compliance advisory engagement file, 2024 to 2025.

An Oracle option is not a feature you own because you bought the database. It is a separate meter, and the meter starts the first time anyone clicks the button.

How do you control Oracle Database EE option costs?

Control starts with measurement and ends with timing. You cannot manage an option bill you have never counted.

Run a feature usage baseline

Pull the database feature usage views across every Enterprise Edition instance. The result is a list of which options were touched, when, and how often. This is the same data Oracle reads.

Separate entitled from used

Lay the usage list next to your contract entitlements. The gap between used and owned is your exposure. The gap between owned and used is your waste.

Negotiate at renewal, not under audit

An option gap found at renewal is a commercial conversation. The same gap found under audit is a compliance claim with back support attached. Move every fix into the renewal window.

What buyer side moves cut Database EE option exposure?

Five moves recur in every estate that keeps its option bill flat.

Move one. Disable default packs

Turn off Diagnostics Pack and Tuning Pack in Enterprise Manager wherever they are not licensed. This stops the most common finding at the source.

Move two. Set a feature gate policy

Require a license check before any administrator enables a paid option. Make the cost visible at the moment of the click.

Move three. Use Standard Edition where it fits

Standard Edition 2 carries no separately licensed options. Workloads that do not need Enterprise features belong there, not on Enterprise Edition.

Move four. Refresh the baseline quarterly

Run the feature usage sweep every quarter. Drift is normal, and a quarterly sweep catches it before it compounds into a finding.

Move five. Engage independent advisory before responding

Never answer an Oracle option script without a reviewed position. An independent read separates real exposure from negotiating theater.

Suggested reading

What should a buyer do next?

  1. Pull the feature usage views across every Enterprise Edition database in the estate.
  2. Map each touched option against your contract entitlements to find the real gap.
  3. Disable Diagnostics Pack and Tuning Pack in Enterprise Manager where they are not licensed.
  4. Move workloads that do not need Enterprise features to Standard Edition 2.
  5. Set a license gate so no paid option is enabled without a cost check.
  6. Schedule any required option purchase for the next renewal, not under audit.
  7. Run the usage sweep every quarter to catch drift early.
  8. Engage independent Oracle advisory before responding to any LMS script.

Frequently asked questions

Are Oracle Database options included with Enterprise Edition?

No. Each option and management pack is licensed separately from the Enterprise Edition database. Buying the database does not grant the right to use Partitioning, Advanced Security, or the diagnostic packs.

Which Oracle option causes the most audit findings?

Diagnostics Pack and Tuning Pack cause the most findings. Both are reachable by default inside Enterprise Manager, so teams use them daily without a purchase, and the database records every use.

How is the per processor price for an option calculated?

Multiply the physical core count by the Oracle core factor, then by the option list price. A 32 core server at a 0.5 core factor counts as 16 processor licenses for each deployed option.

What is the core factor and where is it published?

The core factor is a multiplier Oracle assigns to each processor type. Most modern Intel and AMD cores carry a factor of 0.5. The values live in the Oracle Processor Core Factor Table.

Can I avoid options by using Standard Edition 2?

Yes for many workloads. Standard Edition 2 has no separately licensed options, so the entire option exposure disappears. The trade off is the loss of Enterprise features and a hard core count ceiling.

Does enabling an option once create a license obligation?

Yes. A single use leaves a permanent feature usage flag in the database. Oracle reads that flag during an audit and treats any use as a license requirement, regardless of intent.

How do I see which options my databases have used?

Query the database feature usage statistics views on every Enterprise Edition instance. The output lists which options were touched and when. This is the same data an Oracle audit script collects.

When is the cheapest time to fix an option gap?

At renewal. A gap raised during a renewal is a commercial negotiation with leverage. The same gap raised inside an open audit becomes a compliance claim with back support fees attached.

Oracle ULA Decision Framework

The full Oracle ULA decision framework from the Oracle Practice.

Oracle ULA exit moves, Java audit defense posture, certification framework, and the buyer side moves across the Oracle Database, Java, and EBS estate.

Used across more than five hundred enterprise engagements. Independent. Buyer side. Built for procurement leaders running the next renewal cycle.

No spam. We will only email you about this download. Privacy.
Run the Oracle Java license calculator against your estate in under five minutes.
Open the Tool →

Oracle options are not features. They are meters. The estates that win the audit are the ones that read their own meters before Oracle reads them.

Fredrik Filipsson
Co Founder and Group CEO, Redress Compliance