Number of users in Oracle?

I recently download this script. Quite possibly from one of the ORacle news groups, perhaps here. It is as follows:

select count (*)
from v$session
where username is not null;

This script was labeled as one that would tell me how many users I currently have at any given time. It appears that I am currently over my limit on users because the count returned is 23. This however is not the case. I currently have only 11 users logged on, no batch processes running. I have 12 total licenses and I really would like to manage within that range.

What is v$session supposed to show me. Is it current count, a cumulative total, or what?

Is there a better way to check the total number of users?

-David E. Daniel
Western Michigan University Received on Fri Nov 08 1996 - 00:00:00 CST