Re: Determine max # of concurrent users at schema level

users_max field in v$license is polulated *if* you have set the init.ora parameter LICENSE_MAX_USERS, then this field value is set. This means you can create upto a certain number of users. It does not mean that that many number of named users have connected so far. The original post specifically asked to know how many concurrent sessions were coming from named users, not how many can be created.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Arup Nanda
INET: arupnanda_at_hotmail.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).