Count of users connected to Oracle Apps


How to know how many users connected to Oracle Applications

1:  Use this SQL statement to count number of concurrent_users connected to Oracle apps:

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)

2:  Use this SQL statement to count number of users connected to Oracle Apps in the past 1 hour.

select count(distinct user_id) “users” from icx_sessions where last_connect > sysdate – 1/24 and user_id != ‘-1’;

3:  Use this SQL statement to get number of users connected to Oracle Apps in the past 1 day.

select count(distinct user_id) “users” from icx_sessions where last_connect > sysdate – 1 and user_id != ‘-1’;

4:  Use this SQL statement to get number of users connected to Oracle Apps in the last 15 minutes.

select limit_time, limit_connects, to_char(last_connect, ‘DD-MON-RR HH:MI:SS’) “Last Connection time”, user_id, disabled_flag from icx_sessions where last_connect > sysdate – 1/96;



Nagulu Polagani

"We are all apprentices in a craft where no one ever becomes a master."

Comments

  1. 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)

    What is d.user_name = ‘USER_NAME’ in this query as I have lot of distinct user.. and this query return no rows… kindly reply