By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,843 Members | 864 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,843 IT Pros & Developers. It's quick & easy.

How to find? "Number of Concurrent user"

P: 5
Hi,

Existing running oracle application 11i (11.5.8)
Database version is 8.1.7.4

There is any command / way to know the number of concurrent users for this application.


select SESSIONS_MAX,
SESSIONS_WARNING,
SESSIONS_CURRENT,
SESSIONS_HIGHWATER,
USERS_MAX
from v$license


Sessions Max - Maximum number of concurrent user sessions allowed for the instance.
Sessions Warn - Warning limit for concurrent user sessions for the instance.
Sessions Current - Current number of concurrent user sessions.
Sessions Highwater - Highest number of concurrent user sessions sine the instance started.
Users Max - Maximum number of named users allowed for the database.


for the above query answer is



SESSIONS_MAX :0
SESSIONS_WARNING :0
SESSIONS_CURRENT :103
SESSIONS_HIGHWATER :110
USERS_MAX :0



But i would like to get that what is the maximum number concurrent user ?
if answer likes as above....


could you explain will be greatful,,. advance thanks.

awaiting...

selvan.
Aug 15 '07 #1
Share this Question
Share on Google+
2 Replies


debasisdas
Expert 5K+
P: 8,127
As you have posted a question in the articles section it is being moved to Oracle Forum.
Aug 15 '07 #2

debasisdas
Expert 5K+
P: 8,127
try select from v$session.
Aug 15 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.