Oracle Database License

Oracle’s technology products are primarily licensed using two metrics:

1.Named User Plus.
2.Processor.

The Named User Plus metric is used in environments where users and/or devices can be easily identified and counted. Named User Plus includes both humans and non-human operated devices.
The Processor metric is used in environments where users cannot be easily identified and counted.

In the below senario,let us consider
• Manufacturing company has 15 temperature devices to control the temperature in the warehouse. These devices update the Oracle Database
•30 forklifts are used by 400 warehouse employees to move the contents in warehouse
•Forklift has built-in transponder that updates the Oracle Database EE directly
•Oracle Database is running on a 6-processor server (single core chips)

This product can be licensed by Processor or by Named User Plus metric.
•By Processor: all processors where the database is installed and/or running must be licensed.
• Number of Processor licenses required: 6

• By Named User Plus: the number of licenses required is 1) the Named User Plus minimum (25 Named Users Plus per Processor) OR 2) the total number of actual users accessing the Database (= # of temperature devices + warehouse employees), whichever is greater.
1) 25 * 6 Processors = 150 Named Users Plus
2) 15 temperature devices + 400 warehouse employees = 415 Named Users Plus

• Number of Named User Plus licenses required: 415

License Info can also be found from SQL using this query

select * from v$license;