Technology Stack - EBS (MOSC)

MOSC Banner

maximum concurrent user in the system

edited Apr 6, 2017 5:01AM in Technology Stack - EBS (MOSC) 4 commentsAnswered

Hi:

We are using EBS version 12.2.4

In the oracle application manager dashboard user monitoring, I can see what user are currently login with concurrent program or form.

I found a query on the website which can tell the number of user currently log in to EBS; however, that query is running forever.

select count(distinct d.user_name) from apps.fnd_logins a,

v$session b, v$process c, apps.fnd_user d

where b.paddr = c.addr

and a.pid=c.pid

and a.spid = b.process

and d.user_id = a.user_id

and (d.user_name = 'USER_NAME' OR 1=1)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center