|
|
Dear Erman,
We are in R12.2.5 with 19c Database.
We are trying to find out the peak number of concurrent users in the system. Can you please help us to find it out. We have a query to check the number of users logged in but that didnt help.
SQL> SELECT a.ssdate today_date, COUNT (*) no_of_user_logins
FROM (SELECT icx.user_id, fu.user_name, fu.description, COUNT (*),
TRUNC (icx.creation_date) ssdate
FROM apps.icx_sessions icx, apps.fnd_user fu
WHERE disabled_flag != 'Y'
AND icx.pseudo_flag = 'N'
AND icx.counter < limit_connects
AND icx.user_id = fu.user_id
AND TRUNC (icx.creation_date) >= TRUNC (SYSDATE-4)
AND fu.description NOT LIKE ('%CS%')
AND fu.user_id > 1000
GROUP BY icx.user_id,
fu.user_name,
fu.description,
TRUNC (icx.creation_date)
ORDER BY user_id) a
GROUP BY a.ssdate order by 1;
TODAY_DATE NO_OF_USER_LOGINS
------------------- -----------------
2025-12-22 00:00:00 383
2025-12-23 00:00:00 368
2025-12-24 00:00:00 356
2025-12-25 00:00:00 327
2025-12-26 00:00:00 200
SQL>
Thank You,
Satish
|
Locked
