IN ORACLE MILIEU …

You can check the number of active users currently logged into the application using the following query. 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’); LOGIN_TIME               CNT —————– ———- 26-JAN-2008               26 25-JAN-2008              132 28-JAN-2008               13 [...]