E-learn Weblog of Willem van Valkenburg

select machine
,      to_char(logon_time,'mm/dd/yyyy hh24:mi:ss') Inlogdatum
,      last_call_et Sec_Inactief
,      trunc((sysdate-logon_time)*24)||' H '||trunc(((sysdate-logon_time)-trunc((sysdate-logon_time)*24)/24)*24*60)||' M' aangelogd
,      to_char(trunc(last_call_et/3600,0))||' H '||to_char(trunc((last_call_et - trunc(last_call_et/3600,0)*3600) / 60,0))||' M' inactief
from v$session
where username is not null
order by last_call_et desc;