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
/
Sample Output:
Code: Select all
SQL> 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
/
SQL> 2 3 4 5 6 7
USERNAME Minutes STATUS
-------------------- ---------- --------
SYS 0 ACTIVE
SQL>