查询应用服务器的会话数

/* Formatted on 2018/3/15 12:58:37 (QP5 v5.256.13226.35538) */

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;