Re: Number of users in Oracle?

David E. Daniel wrote:
>
> 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

David,

V$session shows all current oracle sessions, including background processes which make up the oracle instance.

A query like, select username from v$session where type != 'BACKGROUND' will list all users currently connected.

If you are concerned with licenses and number of users, try the v$license view

-- 
Cheers

Sridhar Subramaniam
Avion Consulting Services
Sydney - Australia
Email : avion_at_ozemail.com.au

Disclaimer : All opinions are truly and just mine.