Time since last user activity

Time since last user activity

set lines 100 pages 999
select username
,      floor(last_call_et / 60) "Minutes"
,      status
from   v$session
where  username is not null
order by last_call_et
/

Output:

USERNAME                          Minutes STATUS
------------------------------ ---------- --------
SYS                                     0 ACTIVE
ORA_BLA                                 1 INACTIVE
ORA_BLA                                 1 INACTIVE
ORA_BLA                                 1 INACTIVE
SYS                                     8 INACTIVE
WEBUSER                                29 INACTIVE
WEBUSER                                29 INACTIVE
WEBUSER                                30 INACTIVE
WEBUSER                                30 INACTIVE
REP_USER                            34734 INACTIVE
REP_USER                            34739 INACTIVE
REP_USER                            34744 INACTIVE
REP_USER                            34744 INACTIVE