Re: NUPS license calculations

From: Hemant K Chitale <>
Date: Sat, 4 May 2019 21:51:15 +0800
Message-ID: <>

No. The database has no knowledge of Named Users --- unless every user authorised to connect to the database (either through a Client-Server app or an N-tier architecture) has *his/her own, personal,* database account.

On Sat, 4 May 2019, 03:24 Sundar Mahadevan, <> wrote:

> Thanks Franck for your response. I agree with you. I had the wrong wording
> there. I intended to say NUP users and not database users.
> On Fri, May 3, 2019 at 12:18 PM Franck Pachot <> wrote:
>> Hi Sundar,
>> The NUP+ license has nothing to do with the database users. With NUP you
>> count the end-users. Some examples:
>> - you have an HR application that is used by the HR team of your company
>> where there are 10 people -> that's 10 NUP. Whether they connect with their
>> own user (client/server) or a common account (connection pool) has nothing
>> to do with that.
>> - you have two salespeople who use the application from their PC,
>> laptop, mobile,... through an application server with 150 connections to
>> 150 database users -> that's still 2 NUP
>> -> you are a university with 20000 students, teachers, and alumni and
>> the database application is accessed through public internet but with a
>> login portal that gives access only to those 20000 people -> that's 20000
>> NUP
>> -> this application has some pages that show some data from the database
>> on a public page without login -> that cannot be licensed as NUP as you
>> cannot count the users
>> -> you are a small software vendor with 2 developers but the marketing
>> publishes everywhere that you have 100 developers just to show off...
>> that's 2 NUP but there are good chances that you get an audit because LMS
>> think you need 100.
>> Hope this help. I recommend that you read your contract and the official
>> documents from LMS.
>> Regards,
>> Franck.
>> On Fri, May 3, 2019 at 8:19 PM Sundar Mahadevan <
>>> wrote:
>>> Hi All,
>>> Greetings of the day. I am working on gathering information on our
>>> current license usage. We have NUPS based license and I found v$license
>>> table containing current concurrent users, concurrent users high watermark
>>> along with cpu count (Database versions 9i through 11g on Solaris and 12c
>>> on Linux). Is it safe to assume that the v$license info carries info since
>>> the last database restart considering it is a v$ view? The reason behind
>>> this question is that my company moved from processor based license to NUPS
>>> 8 years or so back and the user base was high during the processor based
>>> license and after company reorg, switched to NUPS due to smaller user base.
>>> Are there any other tables that contain the user info? Thanks for your time
>>> and assistance.

Received on Sat May 04 2019 - 15:51:15 CEST

Original text of this message