Query to find idle time of oracle applications users

select
  disabled_flag,
  to_char(first_connect,’MM/DD/YYYY HH:MI:SS’) Start_Time,
  to_char(sysdate,’HH:MI:SS’) Current_Time,
  USER_NAME,
  session_id,
  (SYSDATE-last_connect)*24*60 Mins_Idle
  from
  icx.ICX_SESSIONS a, apps.fnd_User b
where
  a.user_id=b.user_id
  and last_connect > sysdate-1/24;
  • September 24, 2018 | 23 views
  • Comments