MI Solutions
Insights/Vendor guides
Vendor guides

Oracle Database Licensing Basics for Non-Specialists

Oracle Database licensing explained for non-specialists: Processor vs Named User Plus metrics, the core factor table, the 25-user minimum, editions and options.

By the MI Solutions SAM team10 min read2 exhibits

Oracle Database licensing has a reputation for complexity, but its foundations are simple to state. You license either by processor or by named user. Processor counts depend on physical cores and a core factor. Named users come with minimums tied to processors. And Enterprise Edition options and packs are licensed separately. Most compliance issues come from those last two details.

The four building blocks

01Metric

Processor (compute capacity) or Named User Plus (people and devices that use the database).

02Core factor

A multiplier from Oracle's core factor table, by processor type, applied to physical cores.

03Minimums

For Enterprise Edition, at least 25 Named User Plus licenses per processor license.

04Options and packs

Separately licensed features on top of Enterprise Edition, licensed on the same basis as the database.

Processor vs Named User Plus

Exhibit 1
Named User Plus minimums depend on processor countMinimum NUP licenses for Enterprise Edition on one server with two 8-core Intel CPUs05511016522016Physical cores8Processor licenses (×0.5 corefactor)200Minimum NUP (8 × 25)Example uses a 0.5 core factor typical for Intel processors; check Oracle's core factor table for yourhardware.
01Processor

Licenses the server's compute capacity, regardless of users. Suits systems with many or unknown users, such as customer-facing applications.

02Named User Plus

Licenses the people (and devices) that use the database. Suits internal systems with a known, limited user base, but subject to the per-processor minimum.

Editions, options and packs

Standard and Enterprise editions differ in features and licensing rules. On Enterprise Edition, many capabilities are separately licensed options or management packs. If they are used, they must be licensed for the same processors or users as the database.

Common pitfalls

Exhibit 2
Options, packs and virtualization cause most Oracle database gapsShare of Oracle database compliance gaps by cause in internal reviews, illustrative0%10%20%30%40%Options and packs usedwithout licenses34%Virtualization expandingprocessor count28%Test anddisaster-recoveryenvironments17%NUP below the processorminimum13%Edition rules exceeded8%Illustrative. Proportions vary widely by estate.

See virtualization and licensing for how clusters can extend the processor count.

Oracle database review

How MI One helps

Frequently asked questions

Which metric is cheaper?

For small, known user populations, Named User Plus is often cheaper, subject to the minimum. For large or unknown user bases, Processor licensing is usually required.

Are cloud deployments licensed differently?

Oracle has specific policies for authorized cloud environments. Check them before deploying.

Do test and development databases need licenses?

Generally yes, unless your agreement or a specific program says otherwise. Check before assuming they are free.


Sources

See where your software budget goes

Bring your five largest vendors to a 30-minute call. Our SAM experts will show you where the savings usually hide, and how fast MI One can surface them.