Re: NUPS license calculations

From: Sundar Mahadevan <>
Date: Mon, 6 May 2019 11:56:37 -0700
Message-ID: <>

Thanks all for your response. Are there any other tables other than v$session that I should use for NUP calculation exercise?

On Sat, May 4, 2019 at 6:51 AM Hemant K Chitale <> wrote:

> 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 Mon May 06 2019 - 20:56:37 CEST

Original text of this message