Skip to main content
Question

Monitor User Usage

  • January 31, 2020
  • 1 reply
  • 229 views
jbernardo
Hero (Partner)
Forum|alt.badge.img+13

RUnning FSM 5.7 (UPD 7)

Looking for a way to track user interaction with the system. Within the User record we can see when they logged in and last logged out but we need more. They could be logged in but IDLE all day and not actually working. Any suggestions on how we could pull this data or track it?

1 reply

Sandun Madola
Hero (Employee)
Forum|alt.badge.img+13
  • Sandun Madola
  • Hero (Employee)
  • 145 replies
  • February 3, 2020

Hi @jbernardo ,

Hope below link will help you.
https://dbafox.com/oracle-idle-connections/
 

SELECT sid,
 username,
 status, 
 TO_CHAR(logon_time, 'dd-mm-yy hh:mi:ss') "LOGON",
 FLOOR(last_call_et / 3600) || ':' || FLOOR(MOD(last_call_et, 3600) / 60) || ':' || MOD(MOD(last_call_et, 3600), 60) "IDLE",
 program
FROM gv$session
WHERE TYPE = 'USER'
AND (last_call_et / 60) > &minutes
ORDER BY last_call_et;





 


Terms & ConditionsCookie settingsAccessibility statement