+13RUnning 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?
+13Hi
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;
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.