Skip to main content

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?

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;





 

Reply


Terms & ConditionsCookie settings