set linesize 140 col username format a15 col idle format a15 col program format a30 PROMPT Enter the number of minutes for which the sessions should have been idle: PROMPT 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 v$session where type='USER' and (LAST_CALL_ET / 60) > &minutes order by last_call_et;