天天看点

查询应用服务器的会话数

/* 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