Saturday, June 29, 2019

how many concurrent users do you have at peak ?

REM 
REM SQL to count number of Apps users 
REM Run as APPS user 
REM 
select 'Number of 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; 
REM 
REM 
REM END OF SQL

4 comments:

  1. This comment has been removed by a blog administrator.

    ReplyDelete
  2. This comment has been removed by a blog administrator.

    ReplyDelete
  3. This comment has been removed by a blog administrator.

    ReplyDelete
  4. This comment has been removed by a blog administrator.

    ReplyDelete