How to get number of users connected through frontend -- Oracle Apps
Hi,
My oracle apps version is: 11.5.10
Can you provide any query that provides total number of connected users(through frontend application) at that moment.
I have some queries like:
SELECT distinct icx.session_id, icx.user_id, fu.user_name, fu.description
FROM icx_sessions icx, fnd_user fu
WHERE disabled_flag != 'Y'
AND icx.pseudo_flag = 'N'
AND ( last_connect + DECODE (fnd_profile.VALUE ('ICX_SESSION_TIMEOUT'),
NULL, limit_time, 0, limit_time, fnd_profile.VALUE ('ICX_SESSION_TIMEOUT') / 60 ) / 24
) > SYSDATE
AND icx.counter < limit_connects
AND icx.user_id = fu.user_id
order by 4;
Is this correct?
Or if there are better ways to confirm this?
Tagged:
0