Странице

Ознаке

недеља, 28. децембар 2014.

уторак, 23. децембар 2014.

NUMBER OF USERS LOGGED INTO ORACLE E-BUSINESS SUITE

Number of active users currently logged into the application 
select to_char(START_TIME,'DD-MON-YYYY') Login_Time, count(*) cnt from fnd_logins where START_TIME > (select to_date('25-JAN-2008 00:00:00','DD-MON-YYYY HH24:MI:SS') from dual) and login_type is not null and end_time is null
group by to_char(START_TIME,'DD-MON-YYYY');
Number of sessions for the application using ICX_SESSIONS table
select ((select sysdate from dual)),(select  ' user sessions : ' || count( distinct session_id) How_many_user_sessions
from icx_sessions icx
where disabled_flag != 'Y'
and 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 counter < limit_connects) from dual