Oracle ERP R12. Check EBS timeout - SQL

分享由SQL來查詢各SESSION TIMEOUT的SQL :

SELECT A.DISABLED_FLAG,
       USER_NAME,
       SESSION_ID,
       LIMIT_CONNECTS,
       COUNTER,
       ROUND((SYSDATE - LAST_CONNECT) * 24 * 60) MINS_IDLE,
       TO_CHAR(FIRST_CONNECT, 'YYYY/MM/DD HH24:MI:SS') START_TIME,
       TO_CHAR(SYSDATE, 'YYYY/MM/DD HH24:MI:SS') CURRENT_TIME,      
       FND_PROFILE.VALUE_SPECIFIC('ICX_SESSION_TIMEOUT',
                                  A.USER_ID,
                                  A.RESPONSIBILITY_ID,
                                  A.RESPONSIBILITY_APPLICATION_ID,
                                  A.ORG_ID,
                                  NULL) TIMEOUT_MINS,
       LAST_CONNECT,
       TO_CHAR(LAST_CONNECT +
       (FND_PROFILE.VALUE_SPECIFIC('ICX_SESSION_TIMEOUT',
                                  A.USER_ID,
                                  A.RESPONSIBILITY_ID,
                                  A.RESPONSIBILITY_APPLICATION_ID,
                                  A.ORG_ID,
                                  NULL)/(24*60)),'YYYY/MM/DD HH24:MI:SS') TIMEOUT_TIME
  FROM ICX_SESSIONS A, FND_USER B
 WHERE A.USER_ID = B.USER_ID
   AND B.USER_NAME NOT IN ('GUEST','SYS','SYSTEM','SYSADMIN')
   AND SYSDATE > (LAST_CONNECT +
       (FND_PROFILE.VALUE_SPECIFIC('ICX_SESSION_TIMEOUT',
                                  A.USER_ID,
                                  A.RESPONSIBILITY_ID,
                                  A.RESPONSIBILITY_APPLICATION_ID,
                                  A.ORG_ID,
                                  NULL)/(24*60)))
   AND A.LAST_CONNECT > SYSDATE - 1
   AND A.DISABLED_FLAG = 'N';