Oracle sessions sorted by logon time SQL Code 1set lines 100 pages 999 2select username 3, floor(last_call_et / 60) "Minutes" 4, status 5from v$session 6where username is not null 7order by last_call_et 8/ Sample Oracle Output: 1USERNAME OSUSER ID STATUS LOGIN_TIME LAST_CALL_ET 2-------------------- …