Count of 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;

select count(distinct user_id) "users"

from icx.icx_sessions

where last_connect > sysdate-1/24

and user_id != '-1';

select limit_time,

limit_connects,

to_char(last_connect, 'DD - MON - RR HH :MI :SS') "Last Connection time",

i.user_id,

u.USER_NAME,

disabled_flag

from icx.icx_sessions i, APPLSYS.fnd_user u

where i.user_id = u.user_id

and i.last_connect > sysdate-1 / 96;