Oracle DataBase licensing Options and queries

How to find the Edition of your Oracle Database:

[root@ProdDB01 ~]# su – oracle
-bash-3.1$ sqlplus ‘/ as sysdba’

SQL*Plus: Release – Production on Tue Mar 25 12:32:46 2014

(c) Copyright 1999 Oracle Corporation.  All rights reserved.

Connected to:
Oracle8i Enterprise Edition Release – Production
With the Partitioning option
JServer Release – Production

SQL> select banner from v$version;

Oracle8i Enterprise Edition Release – Production
PL/SQL Release – Production
CORE       Production
TNS for Linux: Version – Production
NLSRTL Version – Production


No. of Users and CPU/Processors:

SQL> select * from v$license;

———— —————- —————- —————— ———-
           0                0                1                  2          0



From the above, the server I have is an Enterprise Edition used for Production purpose.


Reference: Oracle licensing: License detection

US Oracle Technology Commercial Price List (PDF)


Oracle License Types/Metrics:

Named User Plus: is defined as an individual authorized by you to use the programs which are installed on a single server or multiple servers, regardless of whether the individual is actively using the programs at any given time.

A non human operated device will be counted as a named user plus in addition to all individuals authorized to use the programs, if such devices can access the programs.

If multiplexing hardware or software (e.g., a TP monitor or a web server product) is used, this number must be measured at the multiplexing front end. Automated batching of data from computer to computer is permitted. You are responsible for ensuring that the named user plus per processor minimums are maintained for the programs contained in the user
minimum table in the licensing rules section; the minimums table provides for the minimum number of named users plus required and all actual users must be licensed.


Processor: This metric is used in environments where users cannot be identified
and counted. The Internet is a typical environment where it is often difficult to
count users. This metric can also be used when the Named User Plus
population is very high and it is more cost effective for the customer to license
the Database using the Processor metric.

The Processor metric is not offered for Personal Edition. The number of required licenses shall be determined by multiplying the total number of cores of the processor by a core processor licensing factor specified on the Oracle Processor Core Factor Table which can
be accessed at

All cores on all multicore chips for each licensed program are to be aggregated before multiplying by the appropriate core processor licensing factor and all fractions of a number are to be rounded up to the next whole number. When licensing Oracle programs
with Standard Edition One or Standard Edition in the product name, a processor is counted equivalent to a socket; however, in the case of multi-chip modules, each chip in the multi-chip module is counted as one occupied socket.




Understanding Oracle Database Licensing Policies