Number of Users Connected with Oracle Apps/Count Concurrent_users in Oracle Apps

how many users are connected to Oracle Apps/Count Concurrent_users?

Solution A:

1. One can use this SQL statement to count concurrent_users in 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);

select distinct fu.user_name User_Name,fr.RESPONSIBILITY_KEY Responsibility

from fnd_user fu, fnd_responsibility fr, icx_sessions ic

where fu.user_id = ic.user_id AND

fr.responsibility_id = ic.responsibility_id AND

ic.disabled_flag='N' AND

ic.responsibility_id is not null AND

ic.last_connect like sysdate;

2. In the Oracle Applications Manager, go to the site map, and select the "Applications Usage"

option in the Activity region. There one will be able to report on many usage questions, such as:

Products Installed

Application Users Per Module Summary

Applications Usage Reports

Suppliers

Purchase Line Items Processed - Internet Supplier Portal

Purchase Line Items Processed - Purchasing Intelligence

Order Entry Lines Processed - Ordering Application

Purchase Line Items Processed - iProcurement

Expense Reports Processed - Internet Expense

Invoice Line Items Processed - Accounts Receivables

3. Run the following queries:

    This will give the number of users on the system in the past 1 hour.

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

    This will give the number of users on the system in the past 1 day.

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

    This will show the activity in the last 15 minutes.

           SQL> 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;

 Solution B:

1. Enable Profile Option "Sign-On Audit" at "Form" level.

2. Run "Purge Signon Audit" request.

3. Security:Users -> Monitor" option

 ++++++++++++++++++++++++++++++++

MOS ID: 295206.1

++++++++++++++++++++++++++++++++