How to find? "Number of Concurrent user"

[mktselvan]

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.

[debasisdas]

As you have posted a question in the articles section it is being moved to Oracle Forum.

[debasisdas]

try select from v$session.