Question

Monitor User Usage

  • 31 January 2020
  • 1 reply
  • 216 views
jbernardo
Rank
Userlevel 5
Badge +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
Rank
Userlevel 6
Badge +13

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