query 2

sessions per user

select user_name, count(*) How_many_sessions from icx_sessions icx, fnd_user u

where icx.user_id = u.user_id

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 disabled_flag != 'Y'

and PSEUDO_FLAG = 'N'

group by user_name

order by 2 desc;

　

select count(s.status) ACTIVE_SESSIONS

from gv$session s, v$process p

where

p.addr=s.paddr and

s.status='ACTIVE';

　

select count(distinct user_id) "users" from icx_sessions where last_connect > sysdate - 1/24 and user_id != '-1';